Is there a simpler way to perform bulk updates in Dataverse using Power Automate?

(0) Share

Report

Posted on by Mohamed Selmy

Hi everyone,

I'm working on a Power Automate flow that needs to update hundreds of records in Dataverse. Initially, I used the "Apply to each" loop with the "Update a row" action, but as expected, this approach was quite slow due to the large number of requests.

To improve performance, I created a batch request manually. I used "Apply to each" to build the request body, stored it in variables, and then sent it using a pre-authenticated HTTP request to the Dataverse Web API. This method works, but it feels like a lot of effort for what seems like a common need -> bulk updates.

My question is:

Am I missing a simpler or more efficient way to do this in Power Automate?
Is there a built-in or easier approach to handle bulk operations in Dataverse that I'm not aware of?

Thanks in advance for your help!

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

stampcoin 5,146 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Mohamed Selmy Hi,

Have you tried to use Dataverse connector ?

Article link : how to integrate Power Automate flows with Dataverse

Was this reply helpful? Yes No
Suggested answer

Gabriel G. 831 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi there,

You have many possible approaches:

-Use concurrent execution on the 'Apply to each':

Click on '...' of 'Apply to each'

Activate Concurrent ctrl and set value up to 50 concurrent executions

-Second approach is to use Data Operations connector when possible. It is much more faster than using classic 'get all items' since it gives you a smaller schema and indexed informations, but since Update operation is the same, I'm not sure it will changes many thing in your case:

You can use whatever on the connector, but I pointed on best ones for loop :).

-Last approach is to create a custom workflow to make the updates. Then, you call that custom workflow from a realtime workflow.

I hope it helps!

_____________________________________________________________________________

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.

Was this reply helpful? Yes No