How to Copy all the Site contents from Sharepoint site contaning more than 5 document libraries,page libraries,Lists to Azure Blob through Power Automate

Question

How to Copy all the Site contents from Sharepoint site contaning more than 5 document libraries,page libraries,Lists to Azure Blob through Power Automate

Answer 1

Hello Christy Lisly Esther Udayakumar,

Thank you for posting your query here!

You can use Microsoft Power Automate to copy files from SharePoint to Azure Blob Storage using a manual trigger, get file properties action, and Loop and create Blob actions.

In Power Automate, we can create a cloud flow named like "copy files from SharePoint to Azure" and use the "Get files" action to select files from the SharePoint library. To move the files to Azure, we can use the "Create blob" action and establish an authentication between Power Automate and Azure using an access key. Please note the folder path and file name can be obtained from the dynamic properties of the "Get files" action, but the content needs to be obtained using an additional "Get file content" action.

In order to move files from a SharePoint document library to an Azure Blob Storage Account using Power Automate, you must first identify the file identifier from the SharePoint site and add it to a loop in Power Automate. We can then move the action to read and move the file content inside the loop.

Here is what the flow may look like:

For further reference please check this article: https://glarity.app/youtube-summary/science-technology/copy-files-from-sharepoint-document-library-14752559_1159072

Note: Power Automate has a maximum file size limit for individual files. This limit can vary based on the plan you are using, but typically, it's around 100 MB to 250 MB per file. In order to copy large files from SharePoint to Azure Blob Storage using Power Automate: https://sharepains.com/2022/11/15/copy-large-files-sharepoint-azure-blob/

Similar queries for reference: is there any way to copy the entire folder as it is with all nested folders and files from sharepoint to adls - Microsoft Q&A

https://learn.microsoft.com/en-us/answers/questions/1513111/how-to-copy-folders-and-files-from-a-sharepoint-si

Do let us know if you have any further queries. I’m happy to assist you further.

Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.