How to get the worknotes/additional comments in flow

Xhare
Tera Contributor

Hi Community,

 

How can I get the work notes/additional comments in Flow?
I want to stop the Flow if the additional comments contain 'Yes, SAP IBP tab appears in Excel menu'; otherwise, send another notification to the requestor. I used a trigger on the RITM record, but it's not working.

Xhare_1-1755075447230.png

 

 

Xhare_0-1755075320795.png

 

 

4 REPLIES 4

Musab Rasheed
Tera Sage
Tera Sage

I think your trigger point is invalid, add trigger point like below then use 'if' condition to check for text.

MusabRasheed_0-1755076818035.png

 

Please hit like and mark my response as correct if that helps
Regards,
Musab

Ankur Bawiskar
Tera Patron
Tera Patron

@Xhare 

I believe the trigger->additional comments won't help.

You can use Lookup Record on sys_journal_field where Journal entries are stored.

Check with name=yourTable && Element=comments && Element ID = Record SYS ID

Then use IF flow logic to see if record is present or not

AnkurBawiskar_0-1755078305971.png

 

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

@Xhare 

Hope you are doing good.

Did my reply answer your question?

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

ColtonsR
Giga Contributor

In Flow Designer, you’ll want to add a condition step and point it to the Comments field. By default, the RITM trigger won’t catch journal entries, so you might need to use the “Record Updated” trigger on sc_req_item and set it specifically for changes to comments. That usually fixes the issue.