I wanted to create my own Power BI 📊 report from the data collected by the Copilot Studio Kit. To start with I just wanted a list of agents, and that data was stored in the Agent Details table in Dataverse. I hopped over to My workspace in Power BI, and clicked New Item. 🛠️…
These are just my notes on a couple of different ways to implement Canvas Components and grow into more complex solutions, such as Component Libraries. Board Game Nerd Solution (Data) The Board Game Nerd Solution (Data) includes the core components for Tables and Security Roles. Download the solution at https://mattruma.com/wp-content/uploads/2025/06/BoardGameNerdSolutionData_1_0_0_3.zip. Board Game Nerd V1 Solution…
I ran into a challenge where I wanted to filter a Dataverse table on a Choices column, which allowed for multiple selection. The challenge? There is no easy way to do this in a Power App using Filter without running into delegation issues. 😔 Whenever I run into challenges like this, I usually default to…
Recently, I was playing around with Dataverse and Virtual Tables, specifically with the AdventureWorksLT database in Azure SQL. Note, you can easily import this data by creating a new SQL Database in Azure. In the AdventureWorksLT database there is a table called SalesLT.SalesOrderHeader that has a foreign key relationship to two other tables, SalesLT.Customer and…
I recently had an ask to build a Canvas App for entering Surveys. Surveys consisted of one or more Forms. The Forms are assigned to a Survey and then filled out in a specified order. I decide on Dataverse as data store, but could really be anything, SQL Server, and dare I say, SharePoint. Note,…
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…
