Copy excel file from storage account and upload to sharepoint using logic apps

Question

I am trying to automate how to upload an excel into sharepoint from storage account using Logic apps.

Has anyone did it before? Thanks in advance!

Copy excel file from storage account and upload to sharepoint using logic apps

Answer 1

Hello Sadirit Mendigoria

Thank you for posting your query here!

You can use Azure Logic Apps to copy an Excel file from an Azure Storage account to SharePoint. You need to create a new Logic App. Set up a connection to your Azure Storage Account and a connection to your SharePoint site in Azure Logic Apps.  Then, add “When a blob is added or modified (properties only)" trigger for the Azure Blob Storage. Then, you can use the "Get blob content" action to retrieve the contents of the Excel file. After that, you can use the "Create file" action to create a new file in SharePoint and upload the contents of the file to it.

After the trigger "When a blob is added or modified", we use "Get blob content" action to get the content of the file. Then add "Create file" action of SharePoint and put the file content which we got from blob to the "File Content" box.

If there are more than one file in your blob storage, you can use "List blobs" action and use "For each" to loop it and then create each of the file in SharePoint.

Please refer to the following links on connecting logic apps with SharePoint as well as Azure Blob-
Connect to Azure Blob Storage - https://learn.microsoft.com/en-us/azure/connectors/connectors-create-api-azureblobstorage?tabs=consumption
Connect to Share Point - https://learn.microsoft.com/en-us/azure/connectors/connectors-create-api-sharepoint

Here is a similar thread- http://datanrg.blogspot.com/2021/05/a-blog-post-about-copying-azure-files.html

Please 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.