cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Super User II
Super User II

Re: Flow to get all the files from sharepoint online

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

Highlighted
Regular Visitor

Re: Flow to get all the files from sharepoint online

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

 

 
Highlighted
Super User II
Super User II

Re: Flow to get all the files from sharepoint online

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

Highlighted
Regular Visitor

Re: Flow to get all the files from sharepoint online

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Users online (7,082)