Will Power automate support getting more than 5,000 items from SharePoint, and can we apply paging?

Question

I have a document library inside SharePoint where the document library contains 1 million documents. Each document has an expiry date.

Now I want to create a scheduled flow which runs daily and get all the documents which have their expiry date = Today.

Now it is expected that the documents which have their expiry date = Today will be more than 5,000 items.

So can anyone guide me on how can I implement this inside the scheduled flow? If I want to do so using CSOM, I would do these steps:

1. CAML query to get the document which have their expiry date = Today + Implement paging to avoid the 5,000 threshold issue.

So inside Power Automate, how can I implement this?

Answer 1

SharePoint REST API returns maximum 5000 items in one API call. In Power Automate flow, there are few ways to get more than 5,000 items:

1. Using Pagination (from action settings) - This setting is specific to few actions
2. Using the Do Until method

You can find detailed steps for above methods in below articles:

1. How to get more than 5000 items from SharePoint Online in Flow
2. Get more than 5000 items from SharePoint with Power Automate

---

Also, there is limitation on how many items will be returned using pagination. It is based on the license/plan profile you are using:

For detailed limitations of Power Automate flows, check below documentation: Limits for automated, scheduled, and instant flows