Ankur Bawiskar
Tera Patron

@MartinV 

share some screenshots

 

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

MartinV_0-1777538824053.png

MartinV_1-1777538876748.png

This error occurs whenever I select a comment or a work note via data pill and put it into the body. 
I also tried using a custom action with a script that pulls from the sys_journal_field table, but the outputs were empty. 

@MartinV 

this is some other error about invalid HTML

see these links

Email validation failed: Email body comprised of invalid HTML 

Send email Action in flow designer fails with the error "Email validation failed: Email body is comp... 

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

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

View solution in original post

Thank you for your reply! I changed glide.email.body_html_validation_rule value to "none" and finally received the comments / work notes in the email. Now I just need to figure out a way to pull the latest ones, because the flow pulls all of them from the WOT and sends them to the email. Probably will have to use a custom action with scripted step for this. 

namanajain
Mega Guru

Hi @MartinV 

namanajain_0-1777373301162.png

Comments and work notes are not stored directly in the Activity stream. They are actually saved in the sys_journal_field table.
That’s why you need to read from sys_journal_field to get the latest comment or work note and then add that text to the email body.
Try to write the script using this table .
Please like the comment if helpful and if u got your answer please mark it as the solution