AA

(2) Share

Report

Posted on by scorpio24

280

Good day experts, have you tried using update item action to update all of the rows in the SharePoint list?

I have a total of 57,000 items and want to update all of it at the same time, scheduled every quarter.

Hope you could help me with this.

Categories:

Building flows

I have the same question (0)

All responses (11)

Answers (0)

MS.Ragavendar 4,977 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Since you are using SharePoint as datasource, It having threshold as 5K Items to process more than that we need to use Pagination.

The flow will now get up to 100,000 records by requesting 5,000 records at a time perform apply to each and use update item in sharepoint list or send http request.

Also set to the degree of Parallelism to maximum value (50) to improve the performance of the flow.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item

Was this reply helpful? Yes No
Suggested answer

SwatiSTW 741 Super User 2025 Season 2 on at

Like (0)

Report

Updating 57,000 items in a SharePoint list at the same time using the "Update Item" action in Power Automate is not feasible due to SharePoint's throttling limits and API request limitations. You need a batch processing approach to update items efficiently

Solution 1 - Use Power Automate with a Recurrence trigger, Get Items (with pagination), and Send an HTTP request to SharePoint to batch update 1,000 items at a time using REST API. Introduce a 5-10 second delay every 5,000 updates to avoid throttling.

Batch Update Request (Power Automate - REST API)

Solution 2 - Use PnP PowerShell with Azure Automation for efficient bulk updates

Was this reply helpful? Yes No
MS.Ragavendar 4,977 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

Hope this link will guide you how to update (bulk) request in Power Automate using Batch Process in Send Http Request

https://sharepointcass.com/2020/04/25/writing-batch-sharepoint-api-calls-in-power-automate/

https://www.linkedin.com/pulse/10-sharepoint-send-http-request-api-examples-power-automate-broschk-rc1mf

Was this reply helpful? Yes No
scorpio24 280 on at

Like (0)

Report

Hi @MSR@08012015 thank you for this. Can you please provide a screenshot of example workflow for Send HTTP Request?

Was this reply helpful? Yes No
MS.Ragavendar 4,977 Super User 2025 Season 2 on at

Like (0)

Report
Hi,

The below links provide step by step guide for batch update using power automate.

https://anjcerbolles.com/2022/02/16/batch-update-of-sharepoint-list-item-using-power-automate/

https://ashiqf.com/2020/06/16/batch-sharepoint-requests-get-post-patch-delete-in-powerautomate-and-ms-graph/

If you facing challenge please let me know.

Recommendation

if you updating big records, go for some schedule jobs using Web Jobs or Azure Logic Apps, because as your data grows beyond the threshold capacity of batch operation, your business logic needs to revamped. Currently you are saying 57k what if over the years if the data gets double or tripled or even more.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item

Was this reply helpful? Yes No
scorpio24 280 on at

Like (0)

Report

@MSR@08012015 tried using the Send Http Request in SharePoint however, the flow still stops when the 10,000 limit is reached. only the first 10k in the list is updated. Any solution with this?

Was this reply helpful? Yes No
MS.Ragavendar 4,977 Super User 2025 Season 2 on at

Like (0)

Report
Hi,

Get the items and sort in asc order and pass the item to update.

Create a variable - Items Counter - total items count which you retrieved.

You might have already defined the batch size right (1000/2000/3000/5000) per batch right.

Create a Do Until action Items Counter =0.

After every batch completed reduce Items Counter value accordingly based on the batch size.

So It will process all items in the loop, all items will get updated.

Hope this helps.

Was this reply helpful? Yes No
scorpio24 280 on at

Like (0)

Report

@MSR@08012015 I've already have a flow same to your instruction. Get items and updating the item is already per batch inside the Do Until. after 2 batches (1-5000 and 5001 to 10000), the flow ends.

Was this reply helpful? Yes No
MS.Ragavendar 4,977 Super User 2025 Season 2 on at

Like (0)

Report
Scorpio,

Can you please the full flow screenshot.

I have tried previously using the same approach, In one variable get the total times count, condition variable greater than 0 after http request batch update increment the variable with - batch size.

this will continue till the item count zero when reaches zero it ends.

Queries

Initially with get items what is threshold value you provided ?

Let us assume to already got the total item count using get items and set the count of items in variable and Do Until loop

Setting the counter value and defining the batch and update the values.

Why again get items inside the do until again?

Was this reply helpful? Yes No
scorpio24 280 on at

Like (0)

Report

@MSR@08012015 is it possible to show sample screenshot only of your flow so I can follow the proper steps on batching?

My Get items is inside the loop since it is only getting 5,000 items. Since it is a scheduled flow, I cannot set its settings to pagination 100000.

Do Until - Update Item formula is: int(variables('ctrZ')) is greater than int(variables('intBatch'))

Was this reply helpful? Yes No