I am not very familiar with Power Automate or Sharepoint. I recommend also asking this question on their dedicated forum. That being said, I did find a few options which might work for your use case. You didn't say whether or not you are using Azure Blob or Azure Files, each of these have a connector that can be used so including options for both:
- Using Azure File Storage: This method requires the use of the ‘Get file content’ action from the Sharepoint connector and the ‘Create file’ action from the Azure File Storage connector. The file content from Sharepoint is passed as the input for the Azure File Storage action.
- Using Azure Blob Storage connector: This method is similar to the previous one, but uses the Azure Blob Storage connector instead of the Azure File Storage connector. The ‘Copy files from a SharePoint folder to a AzureBlob folder’ template can be used as a reference.
- Using AzCopy utility: This method involves using the ‘Run PowerShell script’ action and the AzCopy utility to copy the files from Sharepoint to Azure Blob Storage. The AzCopy utility needs to be installed on the machine running the Power Automate Desktop flow.
- Using Azure Data Factory: This method is more complex and requires setting up a web activity, a linked service, and a copy data activity in Azure Data Factory to access and copy the Sharepoint files. This method can handle large volumes of data and supports incremental loading
Hope this helps! Please reach out to the Power Automate community if you need further assistance.
If you still have questions, please let us know in the "comments" and we would be happy to help you. Comment is the fastest way of notifying the experts.
If the answer has been helpful, we appreciate hearing from you and would love to help others who may have the same question. Accepting answers helps increase visibility of this question for other members of the Microsoft Q&A community.
Thank you for helping to improve Microsoft Q&A!