I have a document library with the document set content type and document content type in it. In the document library there is more than than 8 Lakhs (0.8 million) document. In the "My Document" content type there is a "DocumentStatus" choice column which has value Draft, In Progress, Approved, no default value is set in it - so, there are thousands of documents which has no "DocumentStatus" value.
I want to find all documents where "DocumentStatus" is empty from this big document library. I tried the Do Until loop approach to get more than 5000 items using Power Automate but it is executing for 2 cycles which is giving 5000*2 =10000 items after that the flow is getting successfully completed. But I want to query all 0.8 million documents, performance doesn't matter for me as it is one time activity.
Was anyone able to retrieve about a million documents using Power Automate successfully?
I am looking for such Power Automate and PowerShell reference. If anyone experienced querying big number of items from SharePoint, requesting to share your knowledge here.