send email with dynamic data

YounseoC
Tera Contributor

Hi, I'm trying to send an email with dynamic data.

 

I made a task with 'Email template', 'Email subject', and 'Email body' fields. When a user selects an email template from the 'Email template' field, 'Email subject' and 'Email body' field will auto-populate with the email template's subject and body values.

When the task is closed complete, it will trigger a flow that sends an email with the task's 'Email subject' and 'Email body' field values.

Email body contains dynamic data such as ${parent.subject_person.name}. I expected the query to get the date from task record, but when I checked the sent email, the dynamic data querys were printed as it is.

 

How can I make the query work? and at which point should the query be substituted with actual data?

6 REPLIES 6

@YounseoC 

I couldn't find those fields on HR Task table

Are those custom ones? Email Subject and Email body?

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Yep they are custom fields