
Announcements
Hello all,
I have created a Power Automate Flow to connect to an external partner's FTP server to download a file at specific intervals via SFTP.
The problem is that I need to use 2 actions to run and I need to terminate the connection once the Flow completes. I cannot test because we are permitted a maximum 2 connections to the FTP server and I am constantly getting a "Bad Gateway" message once the maximum number of connections is exceeded.
The first SFTP-SHH action (List Files in Folder) needs to connect to the FTP server and return a list of files in the required folder.
The second action (Get File Content) is embedded in an "Apply To Each" loop where each filename is checked to see if this matches a specific naming pattern and the contents are then grabbed and a new file is then created on our SharePoint.
Due to the non-termination of the SFTP connection when I try to test the Flow a second time I get a "Bad Gateway" error and cannot modify the Flow as the connection action fails, which prevents me from saving any changes.
Any suggestions?
Thank you 🙂