How to update multiple records in a model-driven app grid using Power Fx commanding
If you wanted to add a button to a command bar to perform an update on multiple records in a grid, you can easily create a formula that results in slow performance caused by multiple grid refreshes. This post outlines, the most performant way of applying updates to multiple records from a Power Fx command button.
Step 1 - Add your button
Inside the modern command bar editor, add a button to the Main Grid or Sub Grid command bars of the Account entity.
Step 2 - Set the Visibility rule
Any buttons on a grid that apply to selected records will only become visible if you provide a visibility rule.
Select the Visibility property, and select Show on condition from formula.
In the formula bar at the top, enter the following:
!IsEmpty(Self.Selected.AllItems)
Step 3 - Add the command formula
Select the Action of the button, and select Run formula.
In the formula bar at the top, enter the following:
// Paralle Updates Patch( Accounts, ForAll(Self.Selected.AllItems, { Account:ThisRecord.Account, 'Credit Hold':'Credit Hold (Accounts)'.Yes } ) )
Note: If you are adding a button for a different entity, you will need to change the table name (Accounts) and primary key column name (Account).
Step 4 - Save and Publish, then Play your app!
The changes will take a short while to appear in your app. You will see a message similar to the following when the changes are ready:
Parallel vs Sequential Patches
If you used the following formula, it would result in multiple grid refreshes since the Patches will be done in sequence.
// Sequential Updates ForAll(Self.Selected.AllItems, Patch( Accounts, ThisRecord, { 'Credit Hold':'Credit Hold (Accounts)'.No } ) );
Using the parallel version above instead of this sequential one will try and perform as many parallel updates as the browser can handle. This is due to the limited number of HTTP requests that can be sent simultaneously from the browser.
You can see in the timeline below, that only 6 parallel requests are in progress at once.
Despite this, this technique will be considerably more efficient than performing the updates sequentially, and the grid will only be refreshed the once, instead of with each record updated.
Published on:
Learn moreRelated posts
Use PowerFX in Power Automate Desktop Flow
Step-by-Step Guide for Using Power Fx in Power Pages (Preview)
In this blog, we’ll explore how to use Power Fx within Power Pages to build dynamic, interactive web applications. We’ll walk through key feat...
Using Power-Fx commands in Vs Code Terminal – Preview
Hi Folks, Looking to improve your experience developing code using Power Fx. Then try this feature which was in preview…I want to show y...
Enhancing Knowledge Retrieval with Microsoft Copilot Agents in Dynamics CRM and SharePoint
Studies show that 70% of employees spend unnecessary time searching for information across multiple systems, leading to productivity losses an...
Power Platform – Create and Use Power Fx Functions Public preview
We are introducing the public preview for Create and Use Power Fx Functions in Power Platform. This preview will streamline the process for cr...
Microsoft Releases Custom Power Fx Functions Feature for Power Automate
Today Microsoft released custom Power Fx functions to support reusable code within Power Automate. In this post how to create and use these cu...
{How to} become MCT Microsoft Certified Trainer on Microsoft Dynamics 365 Customer Engagement step by step instructions
Hello Everyone,Today i am going to share guidelines on becoming Microsoft Certified Trainer on Microsoft Dynamics 365 Customer Engagement or P...