I had a customer ask me for a recommendation on how to model security for Dataverse tables for a specific use case they had. Let me set the stage, starting with Dataverse tables. In an attempt to minimize confusion, I will call the Business Units native to the Power Platform, Power Platform Business Units, and…
I had a recent ask for how to calculate dates in Power Automate, specifically, given a StartDate and Schedule calculate the NextScheduledDate. 📅 The choices for Schedule consisted of Weekly, Monthly, Quarterly, Biannually and Annually. I created two flows, one to do the calculation 🧮, called Date Add Child Flow (Automated), and another, called Date…
A peer and friend of mine, Jordan Bean, wrote a blog on How to start/stop Azure Container Apps using Logic Apps – Jordan Bean Dev Blog. His challenge? I have a few demo apps running in Azure Container Apps. Container Apps are a great platform for getting “just enough Kubernetes”. However, when I’m not doing…
I wanted to see if I could toggle visibility for a Tab and/or a Section on a Form, whenever an Account record was Activated or Deactivated. First thing I did was make sure the names of my Tabs and Sections were unique. I made the following changes in my form: Now for a little JavaScript…
I accidentally – or purposely, for the sake of having something to figure out – added the Status field for a Car entity to Car Main Form form. Whoops! 🤦♂️ I don’t really need it on the form as Activate and Deactivate buttons will handle setting the Status for me. I clicked on the Status…
Wow! That title was a mouthful! 😊 Let me set the stage. I have the following Dataverse tables: I want to create a Canvas App for managing records in the Many To Many A Item table, that included managing the Many To Many C Item records. I set the Items property of the Gallery to…
I wanted to create an app that allows owners of a Microsoft Entra ID group to manage users. To get a list of all the groups a user owns I tried the Office 365 Groups Connector and the List Owned Groups V2 method. That seemed to only want to return a list of M365 Groups….
Let me set the stage. I have two Connections in my environment that point to the same database server and database, the first one named SQL Server 1 (XXX) and the second one named SQL Server 2 (XXX), where XXX is the name of the database. Both use an implicit connection using SQL Authentication, see…
I was recently inspired by Power Apps Reorder Gallery Items – April Dunnam – SharePoint Siren, an “oldie but goodie” article by April Dunnam. I decided to build my own implementation. I wanted my version to not have a strong dependency on if there was an n-1 or n+1 item in the list, so I…
In a recent solution I had modified the command bar for one of my forms, which creates a Component Library. I ended up not needing the modifications, and deleted the Component Library, only to find out there was still a dependency lurking about. I tried everything to figure out what it was and how to…
