Logic App emails Azure data factory

Question

Hello
I'm implementing a logic app service in order to sent Email with some statical data from the pipelines execution. I'm facing with some problems because I need the data from some output variables and I'm not able to reach them

This is the flow. At the master pipeline I executed many activities as copy,delete and as well a data flow activity. From the data flow activity I need number of records from source and sink

main data flow.

main pipeline with the activities

I need from the Motor_DataFlow per example this -->"RecordsReceived": "@{activity('Motor_DataFlow').output.runStatus.metrics.JsonOutputFile.sources.MotorInputFile.rowsRead}",

Im using this expression -->"RecordsReceived": "@{activity('Execute Janitos_51_Motor_Pipeline').output.runStatus.metrics.JsonOutputFile.sources.MotorInputFile.rowsRead}",

but I'm getting an error that says that runStatus doesn't exists, How can i get data from nested activities from another pipeline??

Answer 1

Hello @Diana Milena Coronado Granados and welcome to Microsoft Q&A.

Before the solution(s), let me explain what is happening.

Details of a given activity are only available to that activity's descendents. Even though the Failure_EmailNotification is a descendent of the Execute Pipeline activity, it is not a descendant of the Motor_Dataflow. This is because the activities are in different pipelines.

There are two ways to solve this.

1. Move the Failure_EmailNotification to the child pipeline. This could place the notification at the end where it is connected to Archive_Files_Processed by both a grey skipped dependency and a red failure dependency.
2. In the Parent pipeline, insert some web activities between the Execute Pipeline and Failure_EmailNotification. These web activities will be used to fetch the pipeline run details via the REST API.