cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate III
Advocate III

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

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Will Get Items action with filter query fails in flow if we have more than 5K items in list.


@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 👍.

View solution in original post

9 REPLIES 9
Highlighted
Super User
Super User

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

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

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Highlighted
Community Support
Community Support

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

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

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Administrator
Administrator

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

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

-Gabriel
Microsoft Power Automate Community Manager
Are YOU a member of your local Power Automate User Group?
Fill out This Form to claim your Community User Group Member Badge!
Highlighted
Frequent Visitor

Will Get Items action with filter query fails in flow if we have more than 5K items in list.

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,

 

Highlighted
Super User
Super User

Re: Will Get Items action with filter query fails in flow if we have more than 5K items in list.

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:

Annotation 2019-03-29 162645.jpg


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

Highlighted
Super User
Super User

Re: Will Get Items action with filter query fails in flow if we have more than 5K items in list.

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

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Highlighted
Frequent Visitor

Re: Will Get Items action with filter query fails in flow if we have more than 5K items in list.

@ScottShearer , can you please help with you thought

Highlighted
Super User
Super User

Re: Will Get Items action with filter query fails in flow if we have more than 5K items in list.


@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 👍.

View solution in original post

Highlighted
Frequent Visitor

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

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?

 

 

Helpful resources

Announcements
firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (9,842)