Skip to main content
SharePoint

Return to Question

added 6 characters in body
Source Link
SP 2022
SP 2022
  • 4.1k
  • 3
  • 18
  • 41

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.

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.

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.

Source Link
SP 2022
SP 2022
  • 4.1k
  • 3
  • 18
  • 41

Query more than 8 Lakhs (0.8 million) documents from SharePoint Online document library using Power Automate

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.