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

Question

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

Answer 1

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:

Connect to OneDrive account:

Select file sources and destinations:

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