Moving pdf files from Sharepoint to Blob Storage Container using Logic Apps

Question

I have created a flow where I am attempting to access the following path: "https://cactuscompany.sharepoint.com/sites/dataengineering". Within this path, there is a library named "Documents." Inside the "Documents" library, there are multiple folders like "Pfizer," "Roche," "AstraZeneca," etc. Each company folder contains both files and subfolders, and each subfolder has its own set of files.

My objective is to copy the PDF files from these folders and subfolders to a blob container. The files should be placed in the blob container without retaining the folder structure, only the files themselves...

However, the current flow only retrieves the list of folder names without including the files. what am I missing?

Answer 1

The design you are using will only list the folder names or file names which are there directly without any folder then those files will be sent.

Below is how we can move all files.

The files in SharePoint:

Below is the design which works for me:

You should use Get Items action. The disadvantage with get items is that you will also get folder name in an iteration.

Output: