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

Flow Get Items returns only 100 entries when "Top Count" box is left blank.

Hi, "Get Items" returns only 100 entries when "Top Count" box is left blank. Hint in "Top Count" box says "Total number of entries to retrieve (default = all)". I would expect that leaving the box empty will return everything. Putting a high number like 9999999 resolve the issue.

 

Screenshot_041718_031811_PM.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Advocate I
Advocate I

Re: Flow Get Items returns only 100 entries when "Top Count" box is left blank.

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: Flow Get Items returns only 100 entries when "Top Count" box is left blank.

Hi @ Dany,

 

 

Do you want the "Get items" action would return all items when the "Top Count" field is left blank?

Microsoft flow 'Get Items" action support to returns 100 items when "Top Count" box is left blank currently,

if you want the "Get items" action would return all items when the "Top Count" field is left blank, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

In addition,if you would like to set the "Top Count" like "9999999",there is a 5000 items limit of sharepoint items, so the "Get items" action would return "Top Count" 5000 items currently,I afraid that there is no way to achieve your needs in Microsoft Flow currently.

 

 

Regards,
Alice Zhang

Highlighted
Advocate I
Advocate I

Re: Flow Get Items returns only 100 entries when "Top Count" box is left blank.

Highlighted
Advocate II
Advocate II

Re: Flow Get Items returns only 100 entries when "Top Count" box is left blank.

If it only returns 100 items it should say that it only returns 100 items. It says right in the box that default=all. I just spent 45 minutes trying to figure out why my flow wasn't working correctly.

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new 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
Users online (8,656)