Skip to main content

Notifications

Community site session details

Community site session details

Session Id : d4b0FPDc7/AkyF3b4h1kS0
Power Automate - Building Flows
Unanswered

Create flow to grab files from FTP and place in Sharepoint

Like (0) ShareShare
ReportReport
Posted on 19 Oct 2021 19:14:34 by 18

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.

 

FTP.JPG

 

 

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

FTP2.JPG

 

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

  • Ellis Karim Profile Picture
    10,938 Super User 2025 Season 1 on 22 Oct 2021 at 17:26:57
    Re: Create flow to grab files from FTP and place in Sharepoint

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

    2021-10-22_18-17-26.png

    2021-10-22_18-24-31.png

    2021-10-22_18-15-33.png

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

    2021-10-22_18-20-48.png

    Username – anonymous
    Password – your complete email address (e.g. yourname@yourname.com) or just use anonymous.

     

    Ellis

  • surlesc Profile Picture
    18 on 22 Oct 2021 at 16:21:09
    Re: Create flow to grab files from FTP and place in Sharepoint

    Have you run this and it worked successfully?

  • surlesc Profile Picture
    18 on 20 Oct 2021 at 15:11:35
    Re: Create flow to grab files from FTP and place in Sharepoint

    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:

     

    flow-error-2.JPG

     

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

     

    flow2.JPG

     

    I am using Box.com 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?

  • Ellis Karim Profile Picture
    10,938 Super User 2025 Season 1 on 20 Oct 2021 at 12:36:44
    Re: Create flow to grab files from FTP and place in Sharepoint

    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:

     

    2021-10-20_13-26-34.png

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

    2021-10-20_13-29-28.png


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

  • surlesc Profile Picture
    18 on 20 Oct 2021 at 02:05:41
    Re: Create flow to grab files from FTP and place in Sharepoint

    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?

  • Ellis Karim Profile Picture
    10,938 Super User 2025 Season 1 on 19 Oct 2021 at 22:58:35
    Re: Create flow to grab files from FTP and place in Sharepoint

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

    2021-10-19_23-39-06.png

     

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


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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 51

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 39 Super User 2025 Season 1

#3
rzaneti Profile Picture

rzaneti 22 Super User 2025 Season 1

Overall leaderboard