Email trigger to multiple receipants

[praneshsapmm]

Hi,

I have this requirement as mentioned below : 

Input 1 : 

Invoice #	Handler ID
123A	A;B;C
345B	A

Input2 :

Hnadler ID	Handler mail id	Handler Name
A	AAA@xxx.com	Smith
B	BBB@yyy.com	John
C	CCC@zzz.com	Kary

How can i send one email including A,B,C for invoice 123A and other email to A for invoice 345B . Also note there is no email id in input 1 . That needs to picked up from Inputy2 .

Thanks

[binuacs]

@praneshsapmm One way of doing this

[gautiergodard]

Hello @praneshsapmm 

You would you be able to dynamically solve this by doing something like the attached workflow.

Hope this helps!

[saiirangam]

@praneshsapmm 

1. Split handler ID using rows to columns and split to rows using delimiter ';'

2. join 2 data sets on Handler ID which results in 4 rows in the J anchor 

3. Connect J anchor output to your table and select group by based on "Invoice #", this will auto create 2 group tables

4, connect to email tool and select the table as the bod of the email and , to email 'Handler mail id'

If this worked for you , please accept the solution