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:
- 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?