Sign-up now and get instant access
Leave a comment
Customized training to master new skills and grow your business.
Beginner to advanced classes taught by Microsoft MVPs and Authors.
In-depth boot camps take you from a novice to mastery in less than a week.
Season Learning Pass
Get access to our very best training offerings for successful up-skilling.
Stream Pro Plus
Combine On-Demand Learning platform with face-to-face Virtual Mentoring.
Quick references for when you need a little guidance.
Summaries developed in conjunction with our Learn with the Nerds sessions.
Digital goodies - code samples, student files, and other must have files.
Stay up-to-date on all things Power BI, Power Apps, Microsoft 365 and Azure.
Earn money by driving sales through the Pragmatic Works' Training Affiliate Program.
It's time to address your client's training needs.
Learn how to get into IT with free training and mentorship.
Discover the faces behind our success: Meet our dedicated team
How can we help? Connect with Our Team Today!
Find all the information you’re looking for. We’re happy to help.
Brian Knight of Pragmatic Works provides a tutorial on how to create a custom button in Power Apps Model-Driven Apps to approve multiple items in a subgrid at once. This eliminates the need to approve or reject items on a product-by-product basis.
1. Edit the Application: Navigate to the solution area and open the app you want to edit.
2. Edit the Command Bar: In the application, go to the 'Products' table and click on 'Edit Command Bar'.
3. Add Button: Add a custom button, name it, and select an icon.
4. Implement Power FX Code:
5. Deploy and Test: After adding the code, save and deploy the application to see the new custom button in action.
Limitations: At the time of the recording, existing buttons could not be disabled using this feature. Third-party tools like Ribbon Workbench are needed for that.
Visibility Control: By default, the button will not appear when items are selected in the subgrid. To control its visibility, add a "Show on Formula on Condition" with appropriate conditions.
Brian concludes by noting that this approach is much faster than the traditional methods of approving or rejecting items individually. It offers a low-code way to enhance user experience and operational efficiency.
ABOUT THE AUTHOR
SQL Server MVP and founder of Pragmatic Works. Brian has been working with SQL Server as a DBA and business intelligence professional since 1998. He has written more than 15 books on the topic and has spoken at dozens of conferences.
Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.