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

Question

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?

Answer 1

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://learn.microsoft.com/en-us/answers/questions/1432348/sharepoint-to-azure-blob-storage