Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Copy file to FTP

(0) ShareShare
ReportReport
Posted on by 26

I am trying to create a flow with the end goal of someone submits a Microsoft Form > it updates a spreadsheet on SharePoint in a Document folder > that excel file is converted to a csv and then copied to a file location on an FTP server. The main issue I am having is the copy file FTP function on Power Automate. It is asking for a "source URL" which I assume is the path for the original spreadsheet that it will copy. I cannot figure out what goes here to point it to the excel file. I have tried every combination of file path I can think of.

 

I have thought about doing the "create file" in FTP instead but every time I do that, the file that gets uploaded to the FTP is corrupt and will not open.


The below snip of my flow is just the beginning to test the copy file portion before I adjust it to point to a SharePoint folder. I still haven't figured out how I will convert it to csv but I have a few ideas. 

 

Any assistance would be greatly appreciated.

 

zking_0-1695757120877.png

 

  • Matthy79 Profile Picture
    Matthy79 4,178 on at
    Re: Copy file to FTP

    Perfect. This looks like a really good flow.

  • zking Profile Picture
    zking 26 on at
    Re: Copy file to FTP

    You're genius. This worked using the following flow. There are a few things left to polish up but this got me over the FTP issue.

    zking_0-1696171606006.png

     

  • Verified answer
    Matthy79 Profile Picture
    Matthy79 4,178 on at
    Re: Copy file to FTP

    I‘ve never used this action but maybe it needs the data in another format. I can try this tomorrow but since you want to upload a csv you should convert it.

     

    it is not possible to convert excel files to csv because they can contain, multiple tables, images and so on but of course you can get the data of one specific table and convert it to csv. There is an action for that. Try to send the output of this data operation action to create your file.

  • zking Profile Picture
    zking 26 on at
    Re: Copy file to FTP

    I was kind of thinking that based off the way it looked. But the description was a little misleading. After not being able to figure it out, I tried the Create file, but kept running into the issue of the file being corrupt and/or not opening. If I made the file name a .xslx, it will not open once moved to the FTP. If I change it to .csv, it just opens in symbols, not the correct data. Is there a trick to this?

    zking_1-1696166543514.png

    zking_2-1696166586432.png

     

     

     

  • Matthy79 Profile Picture
    Matthy79 4,178 on at
    Re: Copy file to FTP

    Hello @zking 

     

    I think you are using the wrong action. This one is for copying one file to another destination on the same ftp. Try "Create file" instead.

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard

Featured topics