Azure Data Factory: parameterize reference to output activity

Question

Hi everyone,

in ADF we are trying to evaluate whether is possible to parameterize the reference to an activity in a dynamic expression, like this:

Pipeline overview:

Expression in Set variable "For error":

I think this will always break validation but jus want to confirm it.

Any workaround?

BR.
Paul Hernandez

Answer 1

Hi @Paul Hernandez ,
Thankyou for using Microsoft Q&A platform and thanks for posting your question here.
As per my understanding you want to know if there is any way to parameterize the reference to an activity. Please let me know if my understanding is incorrect.

It's not possible to call an activity dynamically by using pipeline parameters, however since you want to invoke set variable activity on failure of any of the prior activities, you can consider adding a dummy wait activity on success of both prior activities. If any of the activities fails, the dummy wait activity would be skipped and it would invoke the set variable 'For error' activity.

Kindly refer to the below screenshot:

For more details, kindly check out the following video: Run an activity if any one of set of activities fail in Azure data factory
Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you.
  Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators