Answered

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

(0) Share

Report

Posted on by MihirY

129

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?

Categories:

General topics

All responses (11)

Answers (1)

Sort by

ScottShearer 25,331 Most Valuable Professional on at

Like
a
(3)

Report
Copy link

Link copied!

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 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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 7 on at

Like
a
(0)

Report
Copy link

Link copied!

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 561 on at

Like
a
(0)

Report
Copy link

Link copied!

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 25,331 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@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 7 on at

Like
a
(0)

Report
Copy link

Link copied!

@ScottShearer , can you please help with you thought
Verified answer

Brad_Groux 4,556 on at

Like
a
(6)

Report
Copy link

Link copied!

@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 104 on at

Like
a
(0)

Report
Copy link

Link copied!

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 58 on at

Like
a
(0)

Report
Copy link

Link copied!

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