Excel sheet to csv file in my onedrive and after send to sftp

[Supersan123]

Hi, people.

I have a stream that takes an excel spreadsheet and generates a csv by placing it in my root folder of onedrive but I would like to send it to an amazon server via sftp, is this possible? after created in power automate do i need to use the create file option?

[chsanche]

Hi @Supersan123 

Yes, the SFTP - SSH connector allows you to create files, please check on the following documentation for the connector: https://docs.microsoft.com/en-us/connectors/sftpwithssh/#create-file

Best Regards

--

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions help users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Supersan123]

chsanche

I tried and always the connection failed, I filled in the fields, connection name, Host server address, Username and even put the SSH Private Key but the connection always fails, did I do something wrong? need any more field?

[SCTdan]

Chiming in here because I've been searching for reasons why the new SFTP connector won't work.  I have another flow that's still using the old connector, works fine.  The new connector, with the same info, results in "Test connection failed".  I can connect fine via filezilla and winscp, so it's something on the flow side.

[Supersan123]

SCTdan

How I can use the old connector?I choose create file, this file was create in my one drive(csv)I need use other action before create file?

[SCTdan]

We can't, unfortunately.  The connector is still there, but no actions are available to select.

Stuck until someone from MS can explain what's going on.

[Supersan123]

@SCTdan 

I did it but it was necessary to fill it out to work correctly