cancel
Showing results for 
Search instead for 
Did you mean: 

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.

 

Also, if there is some limitations, like max 5000, the hint in "Top Count" box should says something like "Total number of entries to retrieve (default = all, up to 5000)".

 

Screenshot_041718_031811_PM.jpg

 

Ref:

https://powerusers.microsoft.com/t5/General-Flow-Discussion/Flow-Get-Items-returns-only-100-entries-...

 

Thank you,

Status: New
Comments
Level: Power Up

There is a workaround using "Send an HTTP request to SharePoint" :

  • Init a variable with the first rest api call :

initvar.PNG

  • Do the rest call in a loop :

loop.PNG

Items are stored in body('your_rest_call')?['d']?['results']

  • before the end of the loop, update the NextLink value as following:

NextLink.PNG

where d.__next is body('your_rest_call')?['d']?['results'] and the replace function is 

replace(body('your_rest_call')?['d']?['__next'],'Site_url','')
Level: Power Up

This bug definitely needs fixing - I, like others, have wasted a large amount of time trying to work out why only 100 rows were being returned when it clearly says that the default is all.

rys
Level: Powered On

Microsoft, how is this still a problem. Just change the label to say default=100 and save everyone the trouble of having to figure out why their flow isn't working properly.

Level: Powered On

Looks like the default has been moved up to 200 but still is not sufficient. 

Screenshot_041718_031811_PM.jpg


Level: Power Up

Had i known - then the list of emails I sent this wouldnt have sent 100 emails to everyone.