Catalog notification

[Test-RAJM]

Can you help me understand how to display the next approver's name in the catalog item notification? I want the current approver to be able to see who the next approver will be. Is this achievable through Flow Designer, or does it require scripting?
In the email notification, it should display

[Dr Atul G- LNG]

Hi @Test-RAJM 

I think we can't display the name until the next approver is generated. In many cases, the next approver might be grouped, so how would you handle this? Also, what’s the purpose of showing the next approver and to whom? The requestor can already see the approver in the portal, so why include it in the notification?

[SD_Chandan]

Hi @Test-RAJM ,
use nextApprover in your email body.
var nextApprover = "";
var gr = new GlideRecord('sysapproval_approver');
gr.addQuery('sysapproval', current.sys_id); // RITM or request
gr.addQuery('state', 'requested');
gr.orderBy('sys_created_on');
gr.query();
if (gr.next()) {
nextApprover = gr.approver.name;
}