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

Christy Lisly Esther Udayakumar 0 Reputation points
2024-03-09T10:46:32.2466667+00:00

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

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,209 questions
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,415 questions
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,829 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,565 questions
SharePoint Workflow
SharePoint Workflow
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Workflow: An orchestrated and repeatable pattern of business activity, enabling data transformation, service provision, and information retrieval.
506 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Anand Prakash Yadav 5,525 Reputation points Microsoft Vendor
    2024-03-11T08:57:46.1333333+00:00

    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:
    User's image

    User's image

    User's image

    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.