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.
Perfect. This looks like a really good flow.
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.
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.
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?
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.