Add RITM Approver to catalog item variable or anywhere for that matter...

[Lon Landry4]

Service Catalog Item, I am trying to find the Approver from the RITM (in Flow) and add to an email.

I have seen many solutions posted but none seem to work.

I have tried a combination of :

• Variable -(type) Reference on Approval table [sysapproval_approver]
• Script Includes
• Client Script

Also a script inside of a flow action, but like others who tried solution. Instead of approver - null is returned.

Seriously, for such a common request, ServiceNow does not have a simple way to meet this requirement?

Does anyone have an answer that has been successfully tested?
I have tried everything at link below, but no success.
https://www.servicenow.com/community/itsm-forum/get-the-approver-of-a-ritm-populated-into-a-catalog-...

Thanks for your help,

Lon

[Allen Andreas]

Hello,

You should be able to use a record lookup in the flow, pointing to the sysapproval_approver table and then filter the approval for using the trigger record or RITM record (where ever that is in your pills) and state of Approved. From there, you now have access to the approval record pills and one would be the approver, you can then add that to your email if sending from the flow. If you're triggering a notification, you can pass via event as a parm1 or parm2, etc. Not sure how you're sending the email, but those are some ideas.

Please mark reply as Helpful/Accept Solution, if applicable. Thanks!

[Lon Landry4]

Hi Allen,
Thanks for the reply.

I am getting an error of No Record found in Record lookup.

I am not sure of how to match SYS ID, I have tried pulling in data pills for:

• Requested item
• Requested Item > sys_id
• 

Any ideas how to match RITM Approver from here?

[Allen Andreas · Accepted solution]

Hi,

I mentioned above to use the "approval for" field. I believe your issue now is is that you're using "sys_id" which is the sys_id of the approval record and we want the RITM record as reference.

Please mark reply as Helpful/Accept Solution, as applicable. Thanks!

[Lon Landry4]

Soultion works! Thanks so much Allen, I found this filter to be really unintuitive...