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 😘

View solution in original post

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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,181)