HI. I’m having trouble with a filtered list in an email template.
I’ve got a table (tableX) which includes a filtered list of entries from another table (tableY)
I’m looking to create a workflow email for tableX which includes various details from the entry in tableX along with the list of entries from tableY. But because the Key in tableY is a UNIQUEID the email ends up including a list of UNIQUEID values separated by commas. As one would expect.
How do I get the email, or another virtual column in tableX, to show a list of entries for another column of the UNIQUEID values in the list?
ie - to translate “UNIQUEID1, UNIQUEID2, UNIQUEID3” to “name1, name2, name3”