Hi All,
I have integration scenario in which customer will place a file in SFTP location. I have to read the file and insert into dynamics FinOps.
For this, I am thinking to use Logics App to basically trigger when a new file is created and call FinOps to insert records.
My question is, How can i make sure Logic Apps only triggers when file is completely uploaded and not just created. The file customer will upload will be in 10-100mb in size. I want to make sure that when a file is completely imported then only logic apps triggers.
Also for this kind of integration pattern, what is the best design to use.
Thanks
Hi,
Please try changing the trigger to "When a file is created in a folder".
Hi, We have created similar requirement to fetch file from SFTP location using Power automate. In our case, Bank was dropping files once day so we created recurring flow to run once a day and schedule accordingly. In your case, even if incoming files are scheduled for any time, you can still read files using Actions 'List Files in Folder' and it should provide only files which are uploaded completely. The trigger and action for Logic app will be different.
Adis
136
Super User 2025 Season 1
Sohail Ahmed
81
Jonas "Jones" Melgaard
77
Super User 2025 Season 1