Send email to users in a list from Lookup activity

[amaaiia]

I have a simple Pipeline where I first get a list of emails from a Warehouse, and then send an email to all the emails in the list.

I don't know how to add Lookup results as input in Outlook activity. The output of Lookup activity is as follows: 

I'm adding to "To" filed the dynamic content: 

@activity('get_error_emails').output.value

But I get an error because what I want is a list of email strings, not a list of objects with user_email attribute.

Does anyone know hoy to convert this: 

Into:

"To":['email1@domain.com', 'email2@domain.com']

[NandanHegde · Accepted solution]

There are 3 ways :

1) you can semi colon seperate the recipients within the warehouse while executing the lookup activity

2) pass the value of lookup activity to a for each activity. within for each activity,use set variable activity to append the iterations in a semi colon manner

or 3) expression :

https://stackoverflow.com/questions/58632744/adf-expression-to-convert-array-to-comma-separated-stri...

[NandanHegde · Accepted solution]

There are 3 ways :

1) you can semi colon seperate the recipients within the warehouse while executing the lookup activity

2) pass the value of lookup activity to a for each activity. within for each activity,use set variable activity to append the iterations in a semi colon manner

or 3) expression :

https://stackoverflow.com/questions/58632744/adf-expression-to-convert-array-to-comma-separated-stri...

[Anonymous · Accepted solution]

Hi @amaaiia 
Thanks for using Fabric Community.
Please refer to this link:
Microsoft Fabric - Pipelines - Parse Multiple Email Addresses for the Office 365 Outlook Activity (y...

Hope this helps. Please let me know if you have any other questions.