cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pebcak
Regular Visitor

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

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Paulie78
Super User
Super User

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 😘

View solution in original post

3 REPLIES 3
Paulie78
Super User
Super User

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

Paulie78
Super User
Super User

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
Regular Visitor

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

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (4,626)