How to sync/upload files from Sharepoint to Azure Blob Storage

Luke Field 0 Reputation points
2024-06-27T21:41:40.9633333+00:00

I am currently trying to create a chatbot that has access to a Azure Blob Storage, so that I can ask questions about the files I upload. Most of the files are located in Sharepoint, so I would like the files to automatically be updated in the Blob storage, when they are created or modified in sharepoint, I was wondering if anyone has done this already and could help me?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,995 questions
Microsoft Power Platform Training
Microsoft Power Platform Training
Microsoft Power Platform: An integrated set of Microsoft business intelligence services.Training: Instruction to develop new skills.
188 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Kamil Krawczyk 80 Reputation points
    2024-06-28T08:18:24.78+00:00

    To synchronize files from SharePoint to Azure Blob Storage, you can use several methods. Here's a recommended approach using Microsoft Power Automate:

    1. Create a new flow in Power Automate.
    2. As a trigger, select "When a file is created or modified (properties only)" in SharePoint.
    3. Configure the trigger by selecting the appropriate SharePoint site and document library.
    4. Add the "Get file content" action from SharePoint to retrieve the file content.
    5. Add the "Create blob" action from the Azure Blob Storage connector.
    6. Configure the connection to the Azure Storage account by providing the account name and access key.
    7. In the "Create blob" action, set:
      • Path: /[container_name]/[file_name]
        • Blob content: File content from step 4
        1. Optionally, add an action to send an email notification after successful file upload.
    8. Save and test the flow.

    More:
    https://video2.skills-academy.com/en-us/answers/questions/1432348/sharepoint-to-azure-blob-storage