If you haven’t read Part 1, check it out Adventures with Power Apps: Fun with Canvas Components! (Part 1) – Matt Ruma. This is the next progression in my Canvas App component. I wanted to see if there was a way I could make it more dynamic! I wanted to be able to support X…
Adventures with Power Apps: Fun with Canvas Components! (Part 1)
What are Canvas Components? Canvas components enable low code/no-code developers to build reusable UX components using default Power Apps controls as core building blocks. These custom components can then be shared across app screens or multiple apps both within and across Power Apps environments. Canvas components contributes directly towards Power Apps vision of empowering everyone…
Adventures with Dataverse: Trouble with Formula Columns
I had a recent ask by a customer for how to handle flipping a Yes/No field in a Dataverse table based on a couple of criteria, a Schedule column and Last Perform On Elapsed Days column. Last Perform on Elapsed Days ended up being a Calculated column, instead of a Formula. For some reason, the…
Adventures with Dataverse: Fun with Business Units and Access Teams
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…
Adventures with Power Automate: Fun with addToTime
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…
Adventures with Power Automate: I See Your Logic App and Raise You a Power Automate Flow!
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…
Adventures with Model-Driven Apps: Toggle Element Visibility Based on Dataverse Status Column
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…
Adventures with Model-Driven Apps: Deleting Required Fields from a Form
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…
Adventures with Power Apps: Dataverse, Many-to-Many Relationships and Combo Box Controls
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…
Adventures with Power Apps: Managing Entra Groups with a Canvas App
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….