Power Automate: Bulk Update Records Fast

Key insights

• Apply to each — Traditional Power Automate flows list rows, filter results, then update each row one by one using an Apply to each loop; this works for small sets but gets slow for hundreds or thousands of records.
  
• Concurrency control — Turning on concurrency can speed up loops, but it has limits when actions depend on ordered results or when you hit platform throttling; it may still be fragile at large scale.
  
• Dataverse Web API — Use the Dataverse Web API to send bulk updates in a single request instead of multiple row-by-row updates, which reduces flow runtime and improves scalability.
  
• UpdateMultiple — The Dataverse UpdateMultiple action updates many records of the same table in one call; it requires building a Targets collection in the request body for the records you want to change.
  
• @odata.type — Each record in the API payload must include the correct @odata.type annotation and only the columns you need; rename or set the type field so the API accepts the payload.
  
• Chunking (1,000) — Split large datasets into chunks (commonly 1,000 records per request), prepare each chunk’s payload, send UpdateMultiple via HTTP, and confirm updates to cut runtime and avoid slow row-by-row processing.
  

Keywords

Power Automate bulk update, Bulk record updating Power Automate, Update multiple records Power Automate, Power Automate batch update, Dataverse bulk update Power Automate, Bulk update Dynamics 365 records Power Automate, Bulk update SharePoint list Power Automate, Update many records Power Automate