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…
Adventures with Power Apps: My Quick Create Form Is Not Working! Help!
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…
Adventures with Power Apps: Find Email Addresses in Rich Text Editor
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…
Adventures with Power Platform – Canvas Apps and Components
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…
Adventures with Power Platform: Power Automate, Excel and Office Scripts! Oh My!
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…
Adventures with Power Platform: Toggle Tabs in a Model-Driven App with JavaScript
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…
Adventures with Power Platform – To Do or Not To Do in the Power Platform
This is my first attempt at coming up with a rubric to guide a team on whether an application should be created using the Power Platform or a more traditional development technologies, such as React, Angular, C#, JavaScript, etc. The first place I start is with the audience of the application or applications. Is the…
Adventures with Power Platform – Array Joiner Flow
Most of my life I have been a traditional developer, primarily working with C#. C# has a neat function called String.Join. This function allows the caller to pass in an array of values and a separator character and then returns those results has a concatenated string with each array value separated with the separator character….
Adventures with Power Platform – Why Is The Connection Consent Dialog Allow Button Disabled?
I recently created a Canvas App that uses the SQL Server Connector. I went back and forth with deploying the Solution, which contained the Canvas App and the Connection Reference, from my DEV environment to my TEST environment. I made sure that my Canvas App used my Connection Reference, by removing the SQL Data connection…
Adventures with Power Platform – Short Circuit Model-Driven App formOnSave Event
Let’s say you have a Dataverse record that you want to do some things to post creation, for example, maybe you have special requirements for generating a value for the Primary Name column or need to add records to another Dataverse table, and so on. That begs the question, how would you prevent the user…