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…
I have deployed Power Platform solutions with the in-product Power Platform Pipelines, now I wanted to try it with GitHub Actions. I created a Solution called ALM 2 Solution, real sophisticated name. 😄 My Solution includes these components: The Flow ALM 2 Environment Variable List (Power Apps) uses the Connection Reference ALM 2 Dataverse Connection…
I wanted to discourage makers from creating applications in the default Power Platform environment. Unfortunately, I can’t prevent them from doing so in an easy to set up way. Hmm. 🤔 After giving this some further thought 💡, maybe I can respond to a change in a Dataverse table, that’s where the Canvas Apps are…
