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

[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.

[Paulie78]

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

[Paulie78 · Accepted solution]

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-...

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 😘

[pebcak]

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