Skip to content

Matt Ruma

Adventures in AI, Apps, and Agents That Mostly Behave

  • Home
  • Copilot Studio
  • Power Apps
  • Power Automate
  • Archives
  • About Me

Month: March 2024

Adventures with Model-Driven Apps: Toggle Element Visibility Based on Dataverse Status Column

Posted on March 29, 2024 by mattruma
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…

CategoriesModel-Driven Apps, Power Apps, Power Platform

Adventures with Model-Driven Apps: Deleting Required Fields from a Form

Posted on March 28, 2024 by mattruma
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…

CategoriesModel-Driven Apps, Power Apps, Power Platform

Adventures with Power Apps: Dataverse, Many-to-Many Relationships and Combo Box Controls

Posted on March 22, 2024 by mattruma
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…

CategoriesCanvas Apps, Power Apps, Power Platform

Adventures with Power Apps: Managing Entra Groups with a Canvas App

Posted on March 20, 2024 by mattruma
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….

CategoriesCanvas Apps, Power Apps, Power Platform

Adventures with Power Apps: Canvas Apps and Connection References

Posted on March 18, 2024March 18, 2024 by mattruma
Adventures with Power Apps: Canvas Apps and Connection References

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…

CategoriesCanvas Apps, Power Platform

Adventures with Power Apps: Moving Items Between Galleries

Posted on March 1, 2024 by mattruma
Adventures with Power Apps: Moving Items Between Galleries

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…

CategoriesCanvas Apps, Power Apps, Power Platform
Proudly powered by WordPress Simplent Theme by Rafay