Power Platform Community Forum Thread Details

Hi Community,

I am some questions on how to create connection to my local desktop. I am extremely new to PA so sorry in advance if any of these questions are extremely basic.

My goal was trying to create a flow in PA(cloud) that can automated retrieve excel files from SFTP server and download it to my local desktop. Here is the flow I created and the error message I received. The error message is "Key 'gateway' not found in connection profile" with error code of 400.

My suspicion is that my connection to local desktop fail, so here are my questions:

1. I set my root file to C:\, does this work or I need to be more specific?

2. The username I used for my local PC is the one I retrieve from cmd using "whoami", is this correct?

3. What password I should use for this connection? Should I use my Microsoft password?

4. While searching for solutions, I have encounter multiple people talking about download "on-premises data gateway", do I need it in order to extract files from SFTP to my local desktop?