Unanswered

Use a flow to count how many items are in a SharePoint List

(0) Share

Report

Posted on by Dave373927

I am currently using a flow that is triggered from a PowerApp to count rows in a list using a HTTP request. However can this count over 30,000 to 45,000 items. If not can you do that. I used the "get items" and then the length functions but this stopped working and capped out at over 100 items in the list and didn't recognize any more then that so now use the HTTP get request method which seems to be working fine for the moment. Is there any way to count over 30,000 to about 45,000 items and export it as a variable into PowerApps. These items will be exported at the end of a year into a spreadsheet and archived. Any help would be greatly appreciated. Thank you

Currently used flow.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

ChristianAbata 8,951 Most Valuable Professional on at

Like (1)

Report

hi @Dave373927 if you follow this example Super Simple flow to get more than 5000 SharePoint Items (tachytelic.net) this is the best way to do it now

Was this reply helpful? Yes No
Dave373927 61 on at

Like (0)

Report

Hi @ChristianAbata I see finds the most recent item and outputs the ID could I change it to look for a different field as the ID does not match up with how many items there is and how many items can this handle?

Was this reply helpful? Yes No
ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

hi @Dave373927 yes you can try.

Was this reply helpful? Yes No