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.
Solved! Go to 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:
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:
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 😘
I'm looking at this for you and the solution is almost complete. Will have it for you soon.
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:
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:
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 😘
Many thanks for the excellent demonstration on how to get just the names into array, and then do an except. Hugely appreciated (-:
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
73 | |
26 | |
19 | |
16 | |
15 |
User | Count |
---|---|
145 | |
44 | |
44 | |
33 | |
30 |