I have been battling this problem for months, and Blackbaud has told me that they can't help in any way, since it involves accessing their FTP server via third-party products.
Last year, I built a process in which the SFTP action in Power Automate (PA) watches for file changes on a specific FTP folder. On a nightly basis, an RE7 queue runs and exports a handful of files there. Once the PA flow detects the file updates, it runs a process which involves moving the relevant files to a SharePoint folder where other processes run against it.
This process worked for nearly a year before something changed. Now, the credentials in the PA flow no longer work. They always get locked, requiring me to rotate/reset the credentials, but then they immediately get locked again at the very moment that I copy the new password into the PA flow settings. I simply cannot use PA for this anymore.
I tried transitioning toward using Azure Logic Apps (ALA) instead. This worked, but only for a month; now the problem is the same as with PA (it locks immediately, causing all flows to fail).
What's also interesting is that while I can manually connect to the FTP server using an SFTP extension in my code editor (VS Code), and connect via a Python script, the credentials still eventually stop working within 12-24 hours, requiring me to reset the credentials.
Am I the only one dealing with this repeat-locking of FTP credentials?