Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've created an automation to dump a straight table into an Excel file on SharePoint. Sometimes we will also need to deliver this file to an SFTP destination.
The way I'm doing this is:
This method does create the file in the correct destination within our SFTP site, however, the resulting file is corrupted. Excel can repair the file and the data is correct, however, it would be nice if I could accomplish this without the final output being corrupted.
Is there a better method to accomplish such a file move from SharePoint to SFTP?
Hi @skustes
Instead of Reading data from the SharePoint file and writing it in SFTP File, you can directly Copy/Move the file from SharePoint to SFTP using Copy/Move block of SFTP.
Hi @skustes
Instead of Reading data from the SharePoint file and writing it in SFTP File, you can directly Copy/Move the file from SharePoint to SFTP using Copy/Move block of SFTP.
Thanks @salmankojar, that's the solution I ended up arriving at, as well.