How to Move Files From Blob Storage to SharePoint Using Power Automate

Question

Hello,

I am trying on exporting files from Azure Blob storage to SharePoint using Power Automate. Please can someone provide me or refer me to a resource on the step by step basis on how to do that. And also i will like to do same from SharePoint-Blob Storage still via Power Automate. Thanks

Answer 1

Hello Ibrahim Magaji,

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

If you mean to get the libraries and lists from SharePoint and then iterate over each library and lists. Lastly uploading the files to Blob storage, you may refer the following discussion: https://stackoverflow.com/questions/78100685/copy-files-from-sharepoint-site-content-to-azure-blob-using-logic-apps

Similarly, to copy files from Azure Blob Storage to SharePoint folder using Power Automate, you may refer the steps here: https://stackoverflow.com/questions/58726104/copy-files-from-azure-blob-to-sharepoint-folder-using-microsoft-flow

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.