Power Automate - Get Items limit

(0) Share

Report

Posted on by SamB2

104

Hopefully a simple question, but have had no luck finding an answer online thus far.

I have a SharePoint list with over 150,000 items in. Within the list I have a column called "Status", there are approximately 75,000 items in the SharePoint list, where Status = "In Progress".

I am creating a Flow, that will get all items where Status = In Progress and update the Status column to "Complete". This will be a scheduled Flow that runs daily. I am using a Filter query in the Get Items action "Status eq 'In Progress'".

The bit I am struggling with is I have a requirement to only update 2000 list items per Flow run. I have tried setting the Top Count to 2000, and also enabling pagination and setting the threshold here but am having no luck.

Can anyone advise please?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

UshaJyothiKasibhotla 203 Moderator on at

Like (0)

Report

The limit is by default 5000
For clarification please look at the below link
https://www.hubsite365.com/en-ww/crm-pages/2tips-for-working-with-more-than-100-items-in-flow.htm

Hope this helps
Usha

Was this reply helpful? Yes No
SamB2 104 on at

Like (0)

Report

Thanks @UshaJyothi20 - however when I turn on pagination and set the threshold to 100000, it returns all 75,000 items marked as in progress which is what I want. However I only want to update 2000 items per Flow run.

Was this reply helpful? Yes No
Verified answer

grantjenkins 11,063 Moderator on at

Like (1)

Report

I'd suggest checking out the following post on bulk updating SharePoint lists. You can potentially update 1000 items at a time which would equate to 75 updates for 75,000 items.

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Batch-Update-Create-and-Upsert-SharePoint-Lists/td-p/1365410

Alternatively, albeit a lot slower, you could build two flows (main flow and child flow). The main flow would get all 75,000 items (or however many items are set as In Progress), and chunk the results into groups of 2000, then pass each chunk into the child flow. If we had 75,000 item, the main flow would run once, and would call the child flow a total of 38 times (37 x 2000 and 1 x 1000 = 75,000). So, each child flow run would only update 2000 items.

To do this you would build the child flow first then create the main flow that calls the child flow. If you don't have any luck with the bulk update option then I can share how you could build the main/child flow option.

Was this reply helpful? Yes No