Forum Discussion
Community ChampionPushing inner forEach activities to an outer variable
If your variable is of type 'Array', then the 'Append variable' activity can be used inside each foreach iteration to dynamically append new items to the array variable.
Append variable activity - Microsoft Fabric | Microsoft Learn
Afterwards, the array variable (with the data from the foreach activity) will be accessible for subsequent pipeline activities outside of the foreach activity.
I think the Collection functions are useful for accessing the data from the array variable in subsequent steps:
Expressions and functions - Microsoft Fabric | Microsoft Learn
Also other functions and activities can be useful.
Hi smpa01 ,
Currently Data Factory supports Run a Script activity and send an output summary by email.
I think you can create a Data pipeline and then select Script in the Activities.
Then break it down in detail based on the formatting that needs to be changed.
Eventually it would be possible to push the internal forEach activity to an external email as a Script.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.