Pdf Attachment. How to get a value from a column list

Good morning friends,
I have two tables: ticket and users.
The table users has columns [code], [user_name] and [user_email].
In the table ticket I have [users] column and [email] column, both of type enumlist.
When I select users in the ticket table, in the column [Email] I find the emails of users to send notification, thanks to the formula:
SELECT (users [user_email], CONTAINS ([_ THISROW]. [Users], [code])).


When a new ticket is added, the workflow correctly sends emails to all addresses in the ticket[email] column.
The problem is in the template of pdf attachment. How can I assign document to the individual user, for example: "Hello [Sam] or [Marc] or [Paul].
Please note the order (1,2,3) of the users in the list [users] is exactly the same as that of the associated emails in [email] column.
Thanks for your help.

0 0 193
0 REPLIES 0
Top Labels in this Space