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…
Month: April 2023
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…
Adventures with Power Platform: Generate a Two Column Word Document
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…
Adventures with Power Platform: Default Environment Best Practices
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…
Adventures with Power Platform: Use Quick Create Form on View
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?…
Adventures with Power Platform: Security Role Got Me Again! Ugh!
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…