Answered

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

(6) Share

Report

Posted on by Dany

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.

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (1)

v-yuazh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Dany 27 on at

Like (2)

Report
Copy link

Link copied!

Thank you Alice,

Done!

https://powerusers.microsoft.com/t5/Flow-Ideas/Flow-Get-Items-returns-only-100-entries-when-quot-Top-Count-quot/idc-p/132784#M8356

Was this reply helpful? Yes No
rys 69 on at

Like (13)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

If you want to leave 1 item in your current list and not move the last item over, but want to move everything else, do you put a 1 in top count so 1 item is left in the list? I have to leave 1 item because my Power App goes off of ID # in a formula so that is why I'm asking. Thanks!

Was this reply helpful? Yes No
nanstice 6 on at

Like (1)

Report
Copy link

Link copied!

Agreed, I've just spent a number of hours hitting my head against a brick wall trying to get a flow to work. Then found out it wasn't returning the items because of this behaviour that is different to the built in documentation.

Was this reply helpful? Yes No
srduval 1,760 Moderator on at

Like (0)

Report
Copy link

Link copied!

I think the issue at least as it is today is the pagination, not the "top x", pagination is under advanced settings.

Was this reply helpful? Yes No