How to send multiple records to one email?

Hi ​@vishnu,

thank you for your question. I would suggest to construct the body in Alter format/Column assigner step + Representative create before the Send mail step → you basically create the table line for each record (issue) and then using Representative creator you should be able to concatenate multiple records into one. 

I have only much simpler example where we were concatanating multiple DQ rules and their results into one issue description - each on one line:

But your case should work similar way, it might just require a bit of work to make sure you properly define the HTML body (esp. escaping special characters in the strings might be a bit tricky). But I don’t think there is any other way. 

Alternatively, if possible, there is a Send mail task in workflows that (AFAIK) allows attaching files → so you can generate the records into e.g. a CSV file and attach it into the email.

Please let me know if this helped.

Kind regards,

Anna

Hi ​@anna.spakova 

Thank you for your response!

I have tried your approach, but I faced some issues to reach the desired output. However, I have used another approach. So my requirement was to combine entire row into one line and send those rows to corresponding email. This was achieved in two steps:

Created a Column in Alter Format step where I concatenated all the col with html tags.

Then using the Group Aggregator to concatenate rows and group by Email and put in a col called ‘table’. 

Then import the ‘table’ in the Send Email html body, so that the step will render those record as html scripts.

The final email template looks like this.

Final Plan.

Please let me know if you have any question.

Best Regards,

Vishnu Soman

Hi ​@vishnu ,

this is great! I am happy it works :) And thank you so much for sharing this with us, I am sure this will help a lot of others.

Have a great day!

Anna