Been awhile since my last post, work and time off have been consuming a lot of my time. That being said, lately I have been doing a lot with Copilot Studio, so I thought I would share with you my first autonomous agent created with Copilot Studio. 👏 Before we get started, let’s answer the…
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…
A customer of mine was struggling with retrieving Goals from a Power BI Scorecard using Power Automate and the Power BI Connector, it kept generating the error! 😤 This is the error message. The given key was not present in the dictionary. function: ProjectGoalValueAggregations last line: 11 I wanted to see I could replicate the…
When deploying solutions using Power Platform Pipelines, I ran into a frustrating ‘ImportAsHolding’ error ☠️—triggered by dependencies between deleted flows.
Agilicious is an app designed for a small team managing over 100 clients. It allows users to share completed tasks, current work, and assistance needed, with notifications sent to Teams or Outlook. The app includes components for managing reports, filters, and notifications.
I created a Model-Driven App where I customized the command bar for the main form and added a custom button. I want the custom button to only be visible for existing Dataverse records. Or in other words, when the user clicks New, I want the button to be hidden. 🫥 Now, I’ve done this a…
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…
