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

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…