Power Platform Community Forum Thread Details

Hi Folks!

I have been building a simple automated cloud flow that triggers when a new file is added to a OneDrive folder and copies the file to an AWS SFTP site.

The AWS SFTP site is using public/private key encryption and my connector is setup correctly and works.

(I also validated that this is able to read the AWS site by creating an app that pulls the metadata from a file. So I know the connection is working.) I have been working with a power apps consultant on this but the consultant can't figure out a solution either. Figured I'd send this up to this group to see if anyone can help.

This image is showing the simple metadata pull, which succeeds.

Here's the problem:

I'm using SFTP - SSH / Copy file object and the "Destination file path" is not working.

Example #1: I tried simply using a "/" for the path.

This returns an error:

{ 
 "status": 400, 
 "message": "Path to the destination should include file name.\r\nclientRequestId: a8db5c5a-f6be-4508-8b10-93d3dc2ae0cd", 
 "error": { 
 "message": "Path to the destination should include file name." 
 }, 
 "source": "sftpwithssh-eus2.azconn-eus2-002.p.azurewebsites.net" 
}

Example #2: After some testing, decided to use the full path as shown above in the metadata pull. Included a variable with the filename.

This fails with an Access Denied error:

{
 "status": 401,
 "message": "Access denied\r\nclientRequestId: c9620f09-f675-4021-8bd1-bd23d4da4f91",
 "error": {
 "message": "Access denied"
 },
 "source": "sftpwithssh-eus.azconn-eus-003.p.azurewebsites.net"
}

I've been round and round for hours trying to figure out a solution with no luck. Any ideas out there?

Thanks a bunch!

Mick

Categories:

Building Power Apps