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,624 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

use paging or switch to using the Bulk API

Was this reply helpful? Yes No
Ellis Karim 11,940 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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,978 Moderator on at

Like (1)

Report
Copy link

Link copied!

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