web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Help Needed for Connec...
Power Automate
Unanswered

Help Needed for Connect to Local Desktop

(0) ShareShare
ReportReport
Posted on by

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.

 

MinjieYue_0-1676672023051.png

MinjieYue_1-1676672155398.png

 

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?

 

 

MinjieYue_2-1676672518790.png

 

Thanks in advance!

 

Minjie

Categories:
I have the same question (0)
  • Pstork1 Profile Picture
    68,858 Most Valuable Professional on at

    1) To connect to your local desktop you need to install an on-premises gateway. Install an on-premises data gateway | Microsoft Learn

    2) The file system connector goes through the gateway to connect to shared folders.  YOu can't use c:\ as a root folder, it needs to be a network share.

    The user name and password are probably correct if you did whoami

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 223 Super User 2025 Season 2

#2
Expiscornovus Profile Picture

Expiscornovus 205 Most Valuable Professional

#3
harshdeol Profile Picture

harshdeol 167 Moderator

Last 30 days Overall leaderboard