Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
P_work
Frequent Visitor

Copy activity SFTP is triggering twice on file create event

A trigger that is set to trigger when a file is created in the Lakehouse triggers twice  when the file is create with Copy SFTP activity. What would be needed to have trigger fire once? Note, uploading a file works as expected.

 

1 ACCEPTED SOLUTION
v-venuppu
Community Support
Community Support

Hi @P_work ,

Thank you for reaching out to Microsoft Fabric Community.

Your trigger fires twice because the Copy activity creates temp files first, then renames them. each counts as a "file created" event.

 

Set the trigger to fire only on final files by:

1. Filtering by file extension (e.g., .csv, not .tmp)

OR

2. Copy to a staging folder, then move the completed file to the monitored folder.

This ensures the trigger fires only once per actual file.

 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly.

Thank you.

View solution in original post

5 REPLIES 5
P_work
Frequent Visitor

Option 2 worked as expected.

v-venuppu
Community Support
Community Support

Hi @P_work ,

May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

Thank you.

v-venuppu
Community Support
Community Support

Hi @P_work ,

Thank you for your Response. Please let us know if you have any further issues?

Thank you.

P_work
Frequent Visitor

I will try the solutions, as the staging folder sounds feasible. However, the event details of the trigger show the subject to be the filename duplicated, not a .tmp file.  Option 2 still holds promise.

v-venuppu
Community Support
Community Support

Hi @P_work ,

Thank you for reaching out to Microsoft Fabric Community.

Your trigger fires twice because the Copy activity creates temp files first, then renames them. each counts as a "file created" event.

 

Set the trigger to fire only on final files by:

1. Filtering by file extension (e.g., .csv, not .tmp)

OR

2. Copy to a staging folder, then move the completed file to the monitored folder.

This ensures the trigger fires only once per actual file.

 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly.

Thank you.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

June FBC25 Carousel

Fabric Monthly Update - June 2025

Check out the June 2025 Fabric update to learn about new features.