Retrieve more than 5000 rows of data from SharePoint list

(0) Share

Report

Posted on by Sam70

271

Hi,

By following videos/suggestions available over the net I have created a flow to retrieve records from a SharePoint list. But the flow returns only 5000 rows of data. Being new to the subject, unable to proceed further. Hence need help.

Would appreciate if i get a flow which satisfies my requirement.

Regards

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

lbendlin 8,479 Super User 2025 Season 2 on at

Like (1)

Report

use paging or switch to using the Bulk API

Was this reply helpful? Yes No
Ellis Karim 11,691 Super User 2025 Season 2 on at

Like (0)

Report

As lbendlin has mentioned, you can use Pagination.

I think this setting allows the retrieval of up to 100,000 items.

Ellis

https://elliskarim.com/

Was this reply helpful? Yes No
Suggested answer

takolota1 4,974 Moderator on at

Like (1)

Report

There are ways to get data in 5000 item batches & then combine all the JSON into a single JSON array to get something like the 100,000 pagination pull:

https://community.powerplatform.com/galleries/gallery-posts/?postid=c430e91d-15ab-46c0-9de5-c8e93b11c530

Was this reply helpful? Yes No