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…
I’ll admit it, I am a fan of Model-Driven Apps. ❤️ They are a great way to accelerate the development of applications that make user of Dataverse. Sometimes I may create a Canvas App or two or three that use my Dataverse entities, but somewhere, I always have a Model-Driven App, even if it’s just…
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…
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…
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…
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…
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…
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…
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…
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….
