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.
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
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
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
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.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.