Forum Discussion
Skilled SharerSend email to users in a list from Lookup activity
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:
Into:
"To":['[email protected]', '[email protected]']
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 :
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 (youtube.com)
Hope this helps. Please let me know if you have any other questions.
2 Replies
- NandanHegde
Super User
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 :
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 (youtube.com)
Hope this helps. Please let me know if you have any other questions.