How to capture the error message of the each activity among the multiple activities(3) in a pipeline using single stored procedure

Question

I have a ADF pipeline with 3 different activities in sequence. I want to capture the error message of the activity whichever gets failed. So I have created a stored procedure by passing a parameter with which it can capture using @activity('Activity name').Error.Message

But using that expression I can only get the error message for the specified activity.

How can I capture the error message of any activity (of three activities in the pipeline) This would be the pipeline output as the activities are in sequence.

Answer 1

As far as I know, you need to create three stored procedure to capture error message of correspond activity.

Answer 2

@concat(activity('Activity1').Error?.message,'|',activity('Activity2')?.Error?.message,'|',activity('Activity3')?.Error?.message)