Adventures with Dataverse: Migrating Microsoft SQL Server Tables to Dataverse Tables

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…

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 – 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….