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.
