Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Flow to get all the files from sharepoint online



I am very new to Power Automate. Can anyone tell me the steps to add flow to get all the files from sharepoint online as I need to copy these to azure blob.


Screenshots for the steps will help and save my time.




Memorable Member
Memorable Member

Hello @shobhasrini 

You can use Flow/Power Automate to get all the list and libraries in a SharePoint site.

You can then loop through the list and libraries, and when it is a library, you can retrieve all the files and save them in your Azure blob.

As you are new to Flow/Power Automate, I suggest you to create your flow in steps and see what you get from each action that you add.

Start with a trigger action to Manually trigger a flow (also called an Instant flow).

Add the Get all lists and libraries using the SharePoint connector.

Run the flow and see what you get - note the difference between a list and a library in the output.


I have no idea how the Azure blob storage connector is working, so anyone else can join in 🙂


Try the above and tell us about the result 🙂

Kind regards, John

testflow.pngHi John,


Thank you so much for your quick reply.


I have created a flow (attached screenshot) . But I its not working.


In place of blobname it should take the file name from previous step.  I have written expression like item()?['Value'] not sure if this is correct or not



Hello @shobhasrini 

I can see that you are testing with files in one library and folder - good 🙂


The first loop (Apply to each) that you have, should include the following actions:

Get file content - you should be able to add the needed parameters in the fields.

Still in the first loop, add your Create blob action 🙂

- you can then pass in the file name

- and the file content from the Get file content action


Hope this helps you on the way. Kind regards, John

Hi John,


Thank you for your suggestions. I have redefined my flow. Now its copying the files from sharepoint to azure but how can I add metadata to it.



Thanks in advance.

Helpful resources

MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,056)