databaseazureautomationonedrivedata-ingestion

How to automate the process of Importing data from OneDrive to ADLS gen 2/blob storage?

I am working on a project which requires regular ingestion of data from MS Excel (which is stored in OneDrive) to a cloud storage like ADLS gen 2 or Blob storage gen 2.

I came across a few articles which requires use of logic apps, but I cannot find any alternate solutions (if there are any).

Solution

  • You can make use of Power Automate flow Copy new files to AzureBlob from a OneDrive for Business folder..

    Connect Azure Blob storage with Access key authentication:

    enter image description here

    Connect to OneDrive account:

    enter image description here

    Select file sources and destinations:

    enter image description here

    After selecting all, run the flow, and it will copy the files successfully to the Blob account.