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….
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…
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…
I wanted to generate a Word Document that would display user information from the Dataverse. I wanted to display the results in a table, but the table would not take up the complete width of the Word Document so I wanted support for two columns. To generate my report I created a flow, which I…
This article is just a list of recommended best practices for the Default environment curated from other Power Platform sites. What makes the Default Environment so special? A single default environment is automatically created by Power Apps for each tenant and shared by all users in that tenant. Users with a standard Power Apps/Power Automate…
In my Model-Driven App, I wanted users to be able to use the Quick Create Form when click the New button. Seemed like a pretty simple request, but like most things, it wasn’t. I was able to use the Quick Create From from a Sub-grid or a Lookup, but not a View. What to do?…
As I was “sharpening my saw” with deploying Power Platform solutions from one environment to another I ran into a “gotcha” that took a couple of days to resolve! Ugh! Let me set the stage. In my Dev environment I have a solution that contains the following: The Sample 1 Item List cloud flows consists…
