SharePoint File Copy to Azure using Power Automate or Azure Data Factory

Looking to automatically copy files that are created and updated in SharePoint Online to Azure? I'll show you how using Power Automate and Azure Data Factory.

Documentation

Base URL example for Azure Data Factory HTTP Linked Service

[new-game]

Hello, thanks for sharing walkthrough. I have a question on the same. How do we copy multiple files from SPO to data lake? If multiple files are different type ex. excel, csv...then what is the option...Thanks in advance.

[andrewangeles]

This is a great intro, but how would we extend this to download multiple files from a SharePoint document library. Specifically, if we have a document library with a mixture of file types and names, and we only want retrieve all .CSV with name format of YYYY-MM-DD.csv.

[karthikkannan]

Hey, This is great but I am wondering how do I achieve other way around ( ADLS/Blob Storage to Sharepoint )

[indrayne]

What if we have many nested folders inside document drive and we want to copy all files to our azure data lake storage using ADF and maintaining the same hierarchy there also.

[vgwarelearning]

0:45 i am wondering how you added Power Automate @kirby's Sql talk

[sourabhdubey]

Hi . Thanks for the tutorial. But when I am trying by using Power Automate it is giving me the below error :
This request is not authorized to perform this operation using this permission.
clientRequestId:

[shreyaskulkarni]

Can We auto trigger using ADF, whenever the file is updated ?

[WDF]

Hi how to move all files inside a folder in SharePoint?how to create relative URL?

[NasimaKhatun-jbqo]

Hi I am interested in metadata copy activity as well. Can you explain that as well

[unmanisonawane]

Can you please explain for data ingestion from SharePoint list to Adls ?

[hanifmusa]

Hi. Thanks for the tutorial. Can we do incremental load into SQL warehouse if data in sharepoint has new rows?