How to copy an exact file from sFTP to SharePoint

[ignasdukynas]

Hello

I am using this flow to copy file from sFTP to Sharepoint: https://flow.microsoft.com/en-us/galleries/public/templates/4212abe32e8447008c9c6f9c4c727035/copy-th...

How can I hard type the exact name of the file because the automation copies all files from the given location?

[v-alzhan-msft · Accepted solution]

Hi @ignasdukynas ,

Could you please share a screenshot of the configuration of your flow?

You could take a try to create the flow with step:

1. manually trigger the flow.

2. List files in folder in SFTP.

3. Apply to each files, add a Condition inside the Apply to each to check for the special file name.

4. get file content.

5.Add a create file action to create the file in sharepoint.

I don't have the connection to sftp so I share the example with OneDrive:

Best regards,

Alice   

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ignasdukynas]

@v-alzhan-msft Thanks a lot for the support. I believe I am getting closer but still missing something. Microsoft does not allow me to upload photos to the forum so I share with you my a link: Flow 

1. I would like to trigger the flow whenever the file was updated or created
2. Apply to each- you have "value" but I cannot find such.
3. "If Yes": You have "Get file content" but for me, it wraps around "Apply to each 2"

I believe I have immediately in second step an error because only the first step runs successfully. The second step timed out.

[ignasdukynas]

@v-alzhan-msft  I fixed it. Now it works. Thank you very much for your help.

[v-alzhan-msft]

Hi @ignasdukynas ,

Glad that it could help.

Best regards,

Alice   

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

this is great and works well, but its not stopping  ? it just stays in the running state ? Any ideas ? 

[Anonymous]

You could try this way.

Put the files on Shared Documents of Sharepoint Site.

Enjoy,

---

[chj124]

This example to copy from onedrive does not match the options available when copying from sftp. Any place an actual SFTP sample would be?

[geekyD]

@ignasdukynas, can you please share the whole step? And is your source (FTP data) and destination (SharePoint) on-prem or on the cloud? Or both?

I did get a similar request and I do appreciate any assistance.