I want to use the rejection comment within the workflow.

bonsai
Mega Sage

I want to copy the rejection comment for a requested item into a field in a separate table.

Since the rejection comment is recorded in a "Journal" type field, retrieving it within a flow includes unwanted extra information.

Is there a way to retrieve *only* the comment itself?
It would be ideal if it were managed in a specific table somewhere...

I would like to resolve this using flow actions rather than scripts.

1 ACCEPTED SOLUTION

@bonsai 

I am suggesting to use GlideRecord in set flow variables flow logic

what did you try? share screenshots

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

View solution in original post

9 REPLIES 9

I apologize, but I couldn't quite visualize the workaround.

Which record's value should be retrieved into the string-type flow variable?
I wasn't sure how to identify the target record.

@bonsai 

you can query sys_journal_field with below

Element ID = sysapproval_approver record sysid OR RITM SysId (Based on your requirement), usually rejection happens on Approval record

Element = Comments

💡 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

I'm having trouble configuring "Element = Comments" within the flow.

@bonsai 

I am suggesting to use GlideRecord in set flow variables flow logic

what did you try? share screenshots

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

I finally understand.
So, the solution was to use a script to set the value for the flow variable.

That worked perfectly!