Answered

Compare files in SFTP and OneDrive and only copy files that do not exist in OnDrive

(0) Share

Report

Posted on by pebcak

because reasons, it is not possible to use the new/modified automatic flow to read from the SFTP server, and needs to be a scheduled flow.

Once a file has been placed on the SFTP server (externally controlled), it might stay there for 2 days, or 2 months, but will not be altered, therefore I woudl like to be able to do a "simple" compare of file names, and only copy file names from the SFTP server that do not exist in OneDrive

I found this page https://powerusers.microsoft.com/t5/Building-Flows/Comparing-File-Lists/td-p/64178 which describes a very similar requirement, but I can't work out how to convert the "@empty(body('Filter_array'))" to something that works without the "Edit in advanced mode"

Having been looking at this for a few hours, I now can't see the wood for the trees, and would welcome somebody able to show me what needs to be done.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Paulie78 8,422 Moderator on at

Like (0)

Report

I'm looking at this for you and the solution is almost complete. Will have it for you soon.

Was this reply helpful? Yes No
Verified answer

Paulie78 8,422 Moderator on at

Like (2)

Report

Hi @pebcak ,

Because this is somewhat involved I have made a video response to this question to hopefully explain how you can achieve what you want a bit easier. Please watch:

https://youtu.be/UdT1BpUAfUM

Don't forget to subscribe while you are there 😘😘

Within the video, I refer to a blog post by @DamoBird365 and the link for that blog post is here:

https://damobird365.birdhoose.co.uk/2021/03/20/power-automate-efficiently-perform-union-extinct-and-intersect/

Let me know if you get stuck, and I will try to help you out.

Blog: tachytelic.net

YouTube: https://www.youtube.com/c/PaulieM/videos

If I answered your question, please accept it as a solution 😘

Was this reply helpful? Yes No
pebcak 15 on at

Like (0)

Report

Many thanks for the excellent demonstration on how to get just the names into array, and then do an except. Hugely appreciated (-:

Was this reply helpful? Yes No