Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Create flow to grab files from FTP and place in Sharepoint

I've been trying to get a flow that will grab all files with a folder from an external FTP server and place within a folder in Sharepoint. So far it has been a struggle. I was able to find one that is close to what Im looking for but get and error when on the last step of the flow. I have attached an image of the current flow I'm working with.





So far not much luck trying to get that to work. I also tried another method but this only works when I run a test and not automatically. Here is that flow



If there is any advice on what I can do to get this working that would be amazing! 

Super User
Super User

Try editing the flow so that it has only one Apply to each loop:



For the trigger When a file is added or modified, the trigger does not fire if a file is added/updated in a subfolder

If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Thanks for the reply and tip. I've tried adding a step straight from "get file content" section but when I try to populate file name in the "create file" section it adds the second loop automatically. Am I doing something wrong?

Super User
Super User

Here is an other example of a working flow. It lists files from an FTP site, and saves files that are of type text to a SharePoint site:



Can you try using the Display Name from the dynamic content (although Name should work fine)?


If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

I created a flow similar to the one you last posted and got an error when at the apply to each step. Here is the error I received:




Here is the flow I made that is similar to your except using a recurring trigger.




I am using to FTP from so not sure if that could be causing the error but I haven't had issue normally FTPing into it. Any advice on why the apply to each is erroring?

Have you run this and it worked successfully?

Super User
Super User

Yes, the flow runs fine as along I remember to delete the files from SharePoint before re-running:




If you want to try out the same flow, the site and connection I am using for demo flow is:


Username – anonymous
Password – your complete email address (e.g. or just use anonymous.



Helpful resources

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (2,257)