I have an idea to create a connection from my SFTP to Power Automate back to SFTP
- Pull a nightly CSV from a folder on my SFTP
- Edit CSV document
- Delete Lines not if column D is blank
- Remove Leading zeros from column A
- Post back to different folder on my SFTP
I initially was trying to get the file emailed and then pulled on my my One Drive because that was easier to make a connection. Unfortunately, the email contains a link, not an actual attachment. Now, I'm trying to get Power Automate to pull from an STFP, but when I enter my credentials it gives me an error.
Does this seem reasonable or am I barking up the wrong tree? Totally open to suggestions.