What is the maximum limit for Get Items action in MS flow for SharePoint

[MihirY]

When I use Get Items action, by default i can retrieve only 100 items. But I can change this in settings and I can enable the pagination and i can set the limit for items to retreive. In SharePoint online we cannot have more than 5K items per view. But we can store items more than 5K. Suppose if my list is having one lakh items, and i enabled the paging, and given limit as 1lakh. This will retrieve me 1L items for sure or is there any upper limit for Get Items action?

[ScottShearer]

I asked this question in a recent post and it appears as though there is no documentation available at this time.  My research indicates that you cannot retrieve more than 5000 items .  When you try to configure Get Items to get more than 5000 items in the configuration screen, you see an error indicating that you can't set it above 5000.  However, even if you could retrieve the 6000 items from SharePoint, you'll want to loop through them and there is a hard 5000 limit on the number of iterations in For Each and Do until loops.  The result is that retrieving more than 5000 items may not do you much good.  The guidance is to rely on OData filters to cut down on the number of items that you retrieve from SharePoint.

I will say that as recently as a few days ago, I was able to set Get Item to retrieve more than 5000 items but I am no longer able to do that.

Also, turn paging on if you increase the max number of items for Get Items in the configuration screen/dialogue.

Scott

[v-yamao-msft]

Hi @MihirY,

I agree with @ScottShearer , you could try to turn on the Pagination from the Settings. Or you could also use the Filter query to return filtered items.

Please check the following docs for a reference.

Using Filter Expressions in OData URIs

Limits and configuration in Microsoft Flow

Best regards,

Mabel Mao

[GabrielStJohn]

Hey, @MihirY!

It appears as though @v-yamao-msft would like some more information in order to further assist you properly with your issue. Please share any additional information that was requested in order to decrease the amount of time that it will take for you to be assisted!

Thank you for being an active member of the Flow Community!

-Gabriel
Flow Community Manager

[UjwalN]

I have one query please help.

For instance my list is having 1 Lakh items in it and in Flow I am writinng an action to get items from list with some filter contidions (as per filter condition only 4k records should be returned).

What will be the correct outcome out of below two options.

1. Flow will run perfectly fine.

2. Flow will break since I have 1 Lakh items in list ( more then threshold limt of 5K ).

Thanks,

[MarkStokes]

So, this is interesting.  I was just writing a reply around how to do your own paging over large lists to bring back multiple pages of 5000 items when I though "I'll just test the 5000 limit before I do" and this happened:

Thats right folks, I just did a single Get Items from SharePoint, set the Max Items to 32,000 and it brought back all 31,010 items in my list (the correct number of items in my large list).

So, I wonder how big we can actually go?

- Mark

[ScottShearer]

@MarkStokes
What Flow license are you using? I believe that the limit for SharePoint is still 5000 items unless you have a P2 license.

[UjwalN]

@ScottShearer , can you please help with you thought

[Brad_Groux · Accepted solution]

---

@UjwalN wrote:

@ScottShearer , can you please help with you thought

---

The limitation is 5000 items, regardless of Power Automate license. This is a limit of the SharePoint REST API, and not Power Automate. 

👨🏻‍💻 If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION ☑️. If you find this reply helpful, please consider giving it a LIKE 👍.

[ezFlow]

Hi Everyone,

Will have issue with querying a SharePoint list with 10,000 row?

My query will not return more than 3-5 items, but will there be an issue with a SP with more than 5,000 items?

[Yi66]

are you saying sharepoint REST API has limit for paignation 5000 for import and export to csv ?

[Venkata_Mada]

Hi @MihirY  and All members, 

The Get items action can able to retrieve the 100000 items by setting threshold limit to 100000 max with pagination enable. Also set the top count to 5000