I wanted to create a Power Pages site to manage invoices. I created three Dataverse tables for Product, Invoice and Invoice Item. ⚒️ I created the Power Pages site, with several pages. I added my Lists and Basic Forms to the appropriate pages and added Table permissions. 🔒 I created an Invoice form that displays…
I had a question around what happens to the value of a Dataverse field of type Currency or Decimal when I changed the decimal precision. The question❓, what happens to the underlying values stored in the Dataverse field when the decimal precision is changed? Is it automatically truncated? 🤔 Or is the original value retained…
I had a recent ask by a customer for how to handle flipping a Yes/No field in a Dataverse table based on a couple of criteria, a Schedule column and Last Perform On Elapsed Days column. Last Perform on Elapsed Days ended up being a Calculated column, instead of a Formula. For some reason, the…
I had a customer ask me for a recommendation on how to model security for Dataverse tables for a specific use case they had. Let me set the stage, starting with Dataverse tables. In an attempt to minimize confusion, I will call the Business Units native to the Power Platform, Power Platform Business Units, and…
In a recent solution I had modified the command bar for one of my forms, which creates a Component Library. I ended up not needing the modifications, and deleted the Component Library, only to find out there was still a dependency lurking about. I tried everything to figure out what it was and how to…
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…
