Forum Discussion

tan_thiamhuat's avatar
tan_thiamhuat
Icon for Post Patron rankPost Patron
1 year ago
Solved

Dataflow - Automatically Triggered with Parameters

I am testing something on the Copy Data from SFTP Server to SQL Server, and to be triggered upon arrival of files into the SFTP Server. I am trying to use Parameter for the Filename which is sent to ...
governance
  • v-prasare's avatar
    v-prasare
    1 year ago

    hi @tan_thiamhuat ,

    As we haven’t heard back from you, we wanted to kindly follow up to check if there is any progress on above mentioned issue. let me know if you still need any further help here.

     

     

     

    Thanks,

    Prashanth Are

    MS Fabric community support

tan_thiamhuat's avatar
tan_thiamhuat
Icon for Post Patron rankPost Patron
1 year ago

I get the idea, but where do I put the loop condition to loop through the files for their filenames?

 

v-prasare's avatar
v-prasare
Icon for Community Support rankCommunity Support
1 year ago

Hi tan_thiamhuat,

 

start by using the Get Metadata activity and set the Field List to childItems — this fetches all the file names in the SFTP folder. Then, add a ForEach activity after Get Metadata to loop through each file. Inside the loop, place your If Condition and use @item().name to access the current file name. This lets the pipeline process each file one by one and send notifications with the correct filename

 

 

 

Thanks,

Prashanth Are

MS Fabric community support