File System List files in folder, sub-folders - create and update in SharePoint ??

(0) Share

Report

Posted on by sudosaurus

1,599 Super User 2024 Season 1

Hello,

I am building a flow where I need to copy files from a network drive location to a SharePoint Online site.
For now, I am manually triggering the flow however when complete this will be setup on a daily schedule.

Below I have a File System 'List files in folder' action which connection is pointing to the path it is listing files from:

As you will see from the below Output, it has listed a folder named "Archive" with a Size of "0" and an xlsx file in the main folder path:

However, if I add in a "Get file content using path" action, I am able to see that the "Archive" folder contains other files:

How can I structure my flow so that I can copy files from the source path as well as files in any of it's sub-folders?

I need to be able to copy all files to a flat structure in a SharePoint site, so there's no need to re-create the folders SPO side but only the files that exist inside the sub-folders on the file system side of things.

I've been grappling with for the past couple of days and now coming here for support.

Hoping someone can assist me! 🙂

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

grantjenkins 11,063 Moderator on at

Like (0)

Report

I haven't actually use the File system connectors (our company locks down data gateways fairly strictly).

Looking across the web I couldn't find much with regards to recursively going through folders. However, I did find this post which alludes ot the fact that you can't get nested folders with a single call - very limited indeed. So might need to recursively call the List files in folder to get all the files.

Solved: How to get a flat listing of all files with path f... - Power Platform Community (microsoft.com)

I'd suggest for the initial load to use something like ShareGate (if you have it available) or PowerShell. Then once you have the files uploaded, set the recurring flow to use When a file is created which won't have any issues with nested folders, etc.

Was this reply helpful? Yes No
sudosaurus 1,599 Super User 2024 Season 1 on at

Like (1)

Report

@grantjenkins thanks. I also discovered today that the File System connector has a maximum throughput limit of 30mb per file - so that's put a blocker in our way. I've suggested we use scheduled tasks via ShareGate instead as we already have a subscription with them.

Was this reply helpful? Yes No