Skip to main content

Notifications

Power Automate - Using Connectors
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

  • Pstork1 Profile Picture
    Pstork1 64,722 on at
    Re: Help Needed for Connect to Local Desktop

    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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard

Featured topics