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! 🙂
@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.
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.
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.
Michael E. Gernaey
566
Super User 2025 Season 1
David_MA
516
Super User 2025 Season 1
stampcoin
492