Fabric Data pipeline activity dependency

[Gpop13]

Hi, I have the below dependency set in a fabric pipeline. I need the variable to be set to Failed even when one of the notebooks has failed. In the below case, the failed variable will be invoked ONLY if ALL 3 notebooks fail.

Is there any solution to this (apart from creating 3 different flow from each notebook failure)?

Note - for variable for 'pass' I am okay, as it will be called after ALL 3 are successful.

[nilendraFabric]

Hi @Gpop13 

if you wire the Set Variable activity to trigger based on the failure condition of each notebook, that activity will only execute if all three notebooks fail because dependencies in Fabric pipelines are combined with an AND logic condition

so your requirement should be fine with your current setup 

[NandanHegde · Accepted solution]

please refer the below blog :

https://datasharkx.wordpress.com/2021/08/19/error-logging-and-the-art-of-avoiding-redundant-activiti...

You need to use on completion and then check whether there is any failure in any activity, if yes, then set variable else skip

[v-achippa]

Hi @Gpop13,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @nilendraFabric and @NandanHegde for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue? or let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa