Any one came across a requirement like you need to send the email notification once a team is approved with the list of team member details on the email body.
I have team id as the record id and team member details are available in a smartbox smartobject.
When i do get list on the email body its returning empty when there are multiple team members and if there is only one team member it shows the data.
Hope you got my question. Please help.
Thanks in advance.
As you have discovered dropping a SmartObject list method onto the email body will not display the data as expected.
There are 2 approaches you can take.
Use Activity Destinations to Loop Through Results
This will loop through each item in the list and concatenate the result to the previous results to give you all of the values. If you need to return more than one field you can modify above appropriately.
XML and XSL
The other approach is a bit more complex and involves XML and XSL. I wont go into detail, but basic steps are:
Let me know if you need help of more detailed instructions.