Transfer files from Azure Blob Storage to Onedrive folder

Bisceglia, Octavio {PEP} 6 Reputation points
2022-02-18T17:21:31.343+00:00

Hi,
We have some data-files being generated daily in Azure and placed on a blob-storage but users can only access them by manually downloading them using Azure explorer's download function
What's the recommended way to automate a daily file transfer from Azure blob storage into a sharepoint folder automatically without any manual interaction ?
Appreciate any help please

Azure Files
Azure Files
An Azure service that offers file shares in the cloud.
1,154 questions
Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
2,659 questions
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,409 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,542 questions
0 comments

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alan Kinane 16,781 Reputation points MVP
    2022-02-18T17:56:16.277+00:00

    You can use a logic app in Azure or else Power Automate in Microsoft 365 to do this. There's some blog sites who will provide some how to guides on this, for example this one: https://medium.com/@s.c.vinod/sync-sharepoint-document-library-with-azure-blob-using-logic-apps-bb0def8a8416

    2 people found this answer helpful.
  2. Sumarigo-MSFT 43,321 Reputation points Microsoft Employee
    2022-02-21T07:24:58.193+00:00

    @Bisceglia, Octavio {PEP} Firstly, apologies for the delay in responding here!

    Adding more information to the above response! Limits and configuration reference for Azure Logic Apps - Workflow definition limits

    Access Storage Accounts behind Firewalls from Logic Apps within the same region

    Additional information: You can SharePoint rest api along with azure function app for transferring large files. You should use small byte arrays to so that you won’t run out of memory. If you are using a trigger in logic app, you will need to used dountill step in logic app to make sure the file is completely uploaded since the SharePoint trigger gets triggered even before file is created

    Copy new files to AZURE Blob from a OneDrive for Business folder (https://preview.flow.microsoft.com/en-us/galleries/public/templates/49933434732d4846a1fc0aaae72f8998/copy-new-files-to-azureblob-from-a-onedrive-for-business-folder/)
    Copy files from Azure BLOB storage to SharePoint Document Library

    Please let us know if you have any further queries. I’m happy to assist you further.

    ----------

    Please do not forget to 176284-screenshot-2021-12-10-121802.png and 176233-image.png wherever the information provided helps you, this can be beneficial to other community members.

  3. Nicholas Roeder 21 Reputation points
    2022-09-18T17:37:49.4+00:00

    Can this be done via the api. We have E3 users with one drive accounts. I would like to copy files from azure blob container to a user's one drive.

    I've tried the one drive upload api using the blob url but it doesn't seem to work.

  4. Derrick Ortiz 1 Reputation point
    2022-11-08T23:54:33.283+00:00

    I'm wondering if you got this to work. I've been scratching my head on how I can move all production files to blob storage while allowing my people to maintain the feel of working on local files. We are currently using SharePoint Online as our primary storage.

  5. maxim zayaryuk 0 Reputation points
    2023-01-14T17:40:27.7533333+00:00

    you can do this and without logic app;

    all depends on needs and time/costs that you have to spend;

    it can be done and with custom web app not only with logical apps....,

    0 comments