Show only last comment in notification email

[Cat]

Hi All,

I'm creating a flow to handle incidents on hold awaiting caller (automatically sending follow up emails and then closing if no response), but do you know how I can make it add only the last customer visible comment rather than all customer visible comments when creating the email notification?

[Dr Atul G- LNG · Accepted solution]

Hi @Cat 

https://www.servicenow.com/community/developer-forum/inserting-just-the-last-additional-comment-into...

https://www.servicenow.com/community/service-operations-workspace/get-latest-comments-in-email-notif...

Often, we need to include the latest comments in email notifications.

To display the most recent comment in an email template or notification body, use:

${comments:1}

If you want to show the latest two comments, use:

${comments:2}
cc: @Ankur Bawiskar 

[Ankur Bawiskar]

@Cat 

you can't grab it directly

You can query sys_journal_field for your table and field and sort it with Desc and pick latest record

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Dr Atul G- LNG · Accepted solution]

Hi @Cat 

https://www.servicenow.com/community/developer-forum/inserting-just-the-last-additional-comment-into...

https://www.servicenow.com/community/service-operations-workspace/get-latest-comments-in-email-notif...

Often, we need to include the latest comments in email notifications.

To display the most recent comment in an email template or notification body, use:

${comments:1}

If you want to show the latest two comments, use:

${comments:2}
cc: @Ankur Bawiskar 

[Dr Atul G- LNG]

have a look on solution provided by Ankur. cced him in my last reply.,

[Ankur Bawiskar]

@Dr Atul G- LNG 

not sure if that works in flow's "Send Email" flow action

@Cat did you try in flow?

If not then you will have to query sys_journal_field table as per approach I shared earlier.