Help Needed: Merging Email Lists from Lookup and Security Groups in a Fabric Pipeline

Hi,

Thanks for the response. I was finally able to resolve it as follows:

After the web activity that retrieves the members of the security groups, I added a notebook that processes the results and extracts the "mail" field from each member. This allowed me to generate a list of email addresses associated with the security groups.

Then, I added two "Set variable" activities:

The first one assigns the list of emails to a temporary variable inside the forEach loop.
The second one accumulates the emails into an accumulator variable, which allowed me to build the complete list of emails outside the forEach.
This approach enabled me to successfully retrieve all the email addresses from the security groups and use them in the subsequent steps of the pipeline.