I have a sample application that consists of two tables, Forms and Form Types and a Model-Driven Application called Forms Model App. Currently I have three Form Types: When creating a Form you have to assign a Form Type. I had a new requirement come up. I wanted to allow certain people to have access…
In a previous post, Adventures with Dataverse: Migrating Microsoft SQL Server Tables to Dataverse Tables – Matt Ruma, I walked through migrating a SQL Database to Microsoft Dataverse. In this post, I want to look at adding security roles to control access to the Dataverse entities. The first security role I will create is for…
From time to time, I want to migrate data from Microsoft SQL Server to Microsoft Dataverse. Dataverse offers a lot of capabilities for working with entities within the Power Platform. Sure, I could use virtual tables, but those comes with a lot of limitations. I also wanted to create a pattern for Microsoft SQL Server…
I’ll admit it, I am a fan of Model-Driven Apps. ❤️ They are a great way to accelerate the development of applications that make user of Dataverse. Sometimes I may create a Canvas App or two or three that use my Dataverse entities, but somewhere, I always have a Model-Driven App, even if it’s just…
I had a Power Automate flow that was triggered whenever a record was added to a Dataverse table, which would add a new record to another Dataverse table. Pretty straight forward. Or in other words, whenever a record was added to Dataverse Sample 2 – Parent Items, I wanted to add a row to Dataverse…
I was struggling with getting my Quick Create Form working in my Model-Driven App. From all the documentation I looked at, I thought I had things configured correctly. Sadly, I had missed a step. Thank you Owen_Wetherow, I am indebted to you for helping me to fix this. The answer is found at Solved: Quick…
Recently I was asked to provide an example for how to extract email addresses from a RichTextEditor component in a Canvas App. The extraction would be two fold: The setup of the Canvas App consisted of the following components. It was pretty easy to setup, where I started to run into challenges was then I…
I am working on creating a sample application to inventory books. I needed a header to appear on each screen so I decided to create it as a Component internal to the Canvas App. The Component would have the following properties: In order for the Screen to receive events from the Component, I needed to…
I have been playing around with Office Scripts lately, specifically Office Scripts for Excel. I wanted to create a Power Automate Flow that populated an Excel spreadsheet and then have the pivot table and chart based on the sales data. The spreadsheet consisted of two worksheets, one for car sales data, and another for a…
I recently had a request to demonstrate how to toggle tab visibility based on the value of an entity property, Item, in a Model-Driven App. To complete the ask I used JavaScript and wired it up to the Model-Driven App form events, specifically On Load and On Change events. Try it in your own environment…
