Flow to get all the files from sharepoint online

[shobhasrini]

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

[JohnAageAnderse]

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

[shobhasrini]

Hi 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

[JohnAageAnderse]

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

[shobhasrini]

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.