web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id : UavKY/3/1rxSNOpjYmhmzT
Power Platform Community / Forums / Power Automate - Building Flows / SFTP to on premise server
Power Automate - Building Flows
Unanswered

SFTP to on premise server

Like (1) ShareShare
ReportReport
Posted on 10 Oct 2018 22:25:58 by rsavage16 6

We are BRAND NEW to flow and have a need to connect to a SFTP server, copy the files from that server to a local on premise server.  That folder is then scanned by our ERP software to import.  We set up a On Prem gateway, but can't figure out how to write the flow.

I was able to start from scratch and connected to the SFTP server.  Now lost.  We have a hot project and I can't figure this out. Can anyone please help us get started?

I have the same question (0)
  • cindygurbuzer Profile Picture
    cindygurbuzer 2 on 19 Aug 2019 at 21:54:45
    Re: SFTP to on premise server

    since this is all on-prem i wanted to make sure no data being cashed in the cloud?? 

    CAn you confirm?  

  • GabrielStJohn Profile Picture
    GabrielStJohn on 18 Oct 2018 at 19:48:57
    Re: SFTP to on premise server

    Hello, @rsavage16!

    Thank you for posting on the Flow Community Forum! Have you had an opportunity to apply @v-yamao-msft‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!

    Thank you for being an active member of the Flow Community!

    -Gabriel
    Flow Community Manager

  • v-yamao-msft Profile Picture
    v-yamao-msft on 17 Oct 2018 at 09:13:42
    Re: SFTP to on premise server

    Hi @rsavage16,

     

    The flow is triggered by when a file is created or modified. Following by the action Get file content.

    Then in the file system action create file, use the dynamic content File name from the trigger, file content from the action Get file content.

     

    Best regards,

    Mabel

  • rsavage16 Profile Picture
    rsavage16 6 on 15 Oct 2018 at 15:17:17
    Re: SFTP to on premise server

    I'm really new, so forgive my ignorance.  Why would you have 2 steps fro SFTP?  The first one would connect to the server.  What is the second doing?

  • v-yamao-msft Profile Picture
    v-yamao-msft on 15 Oct 2018 at 08:11:43
    Re: SFTP to on premise server

    Hi @rsavage16,

     

    Do you want to copy file from SFTP server to a local folder?

    It seems that you have created a connection to SFTP Server. To copy the file to a local folder, please consider using connector File System.

    The flow could be configured likes below:

    1.PNG

    Before using File System connector, please create the connection properly. More details in the following doc:

    https://docs.microsoft.com/en-us/connectors/filesystem/ 

     

    Best regards,

    Mabel

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

News and Announcements

Welcome to the Power Platform Communities
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

MS.Ragavendar – Community Spotlight

We are honored to recognize Ragavendar Swaminatha Subramanian as our September…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 954 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 650 Moderator

#3
trice602 Profile Picture

trice602 327 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans