cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shobhasrini
Regular Visitor

Flow to get all the files from sharepoint online

Hi,

 

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.

 

Regards,

P

4 REPLIES 4
JohnAageAnderse
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.

 

testflow1.png

Thanks in advance.

Helpful resources

Announcements
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,037)