Power Platform Community Forum Thread Details

I am trying to use power automate to automate a daily process of connecting to a sftp, downloading files onto my local drive. My biggest issue is I am unable to whitelist all of the IP addresses associated with Microsoft and can only connect using the IP address from my office. I attempted going around this by using power automate's CMD functionality but I am unable to insert the password doing this. So my problem has two different paths to the same result and was wondering if either are possible, and if so how to do it.

1. Connect to SFTP using power automate using my local IP address

2. Connect to SFTP using the CMD/terminal functionality within Power Automate and give commands through that.

If there is another solution using task scheduler or something else, I am very open to all and any suggestions.

Categories:

Using connectors

Hi I am also facing login issue:

Correlation Id: 84d13c11-10be-4ef8-9b3b-2bda76f7028a

Permission denied (password).: Microsoft.PowerPlatform.PowerAutomate.Desktop.Actions.SDK.ActionException: Can't login to xxx.xxxxx.com. ---> Renci.SshNet.Common.SshAuthenticationException: Permission denied (password).
at Renci.SshNet.ClientAuthentication.Authenticate(IConnectionInfoInternal connectionInfo, ISession session)
at Renci.SshNet.ConnectionInfo.Authenticate(ISession session, IServiceFactory serviceFactory)
at Renci.SshNet.Session.Connect()
at Renci.SshNet.BaseClient.CreateAndConnectSession()
at Renci.SshNet.BaseClient.Connect()
at Microsoft.Flow.RPA.Desktop.Modules.FTP.Actions.OpenSecureFtpConnectionAction.InitializeSftpConnection()
at Microsoft.Flow.RPA.Desktop.Modules.FTP.Actions.OpenSecureFtpConnectionAction.Execute(ActionContext context)
--- End of inner exception stack trace ---
at Microsoft.Flow.RPA.Desktop.Modules.FTP.Actions.OpenSecureFtpConnectionAction.Execute(ActionContext context)
at Microsoft.Flow.RPA.Desktop.Robin.Engine.Execution.ActionRunner.Run(IActionStatement statement, Dictionary`2 inputArguments, Dictionary`2 outputArguments)