Logic apps trigger only when file is complete

(0) Share

Report

Posted on by JeffGreenrc

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

I have the same question (0)

All responses (2)

Answers (1)

Suggested answer

Mohit Rampal 12,565 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

Eiken on at

Like (0)

Report

Hi，

Please try changing the trigger to "When a file is created in a folder".

Was this reply helpful? Yes No