Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I have a child pipeline (Pipeline A) where, at the end, I use a Set Variable activity to produce a dynamic output that looks like this:
{
"name": "emails",
"value": [
"aa@xx.com",
"bbb@xx.com",
"ccc@xx.com"
]
}
I want to invoke this result in another parent pipeline (Pipeline B) using the Invoke Pipeline activity.
The issue is that the Pipeline Return Value option only lets me provide a plain text value and doesn’t allow me to dynamically pass the output generated by the child pipeline.
How can I pass this dynamic output from the child pipeline to the parent pipeline and use it as an input for other activities (for example, a ForEach loop)?Any suggestions, best practices, or working examples would be greatly appreciated!
Solved! Go to Solution.
Pipeline return value will allow you to do this if you set the type to expression and pass your variable value in. The key step is to convert the variable back from a string using the `@json` function, so it can be used by the for each loop.
It should look something like this `@json(variables('var'))` you can either do that in the set variable task that is setting the return value, or in the `items` section of the for each loop.
Hello @liney_marcela,
Thank you for reaching out to the Microsoft Fabric Forum Community. Here's how you can approach this issue:
In your child pipeline, at the end of Pipeline A, use the Set Variable activity to create your dynamic output, ensuring you're using the correct structure.
Thank you, @justinjbird for sharing your valuable insights.
If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.
I'd be looking to accept @justinjbird solution as you've simply repeated what he replied with.
Pipeline return value will allow you to do this if you set the type to expression and pass your variable value in. The key step is to convert the variable back from a string using the `@json` function, so it can be used by the for each loop.
It should look something like this `@json(variables('var'))` you can either do that in the set variable task that is setting the return value, or in the `items` section of the for each loop.