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

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022- Season 2 has kicked off!

Users online (4,596)