How to show Approval rejected person name in email notification

[may13]

"Hello team, I have created an email notification on the Core Case (sn_hr_core_case) table. In the notification body, I need to display the name of the person who rejected the approval. Could you please help me with the script to show the rejected person's name?"

[Anand2799]

Hi @may13 ,

Why don't you create notification on sysapproval_approver table?

You can access approver details easily.

Thanks

Anand

[may13]

No As per the requirement we need to create this notification in sn_hr_core_case table 

[Ankur Bawiskar]

@may13 

what's the trigger for that notification?

Are you knowing on HR case if it got rejected?

If yes then you can use email script and query sysapproval_approver table with this HR Case and pick the approver who rejected

what did you start with and where are you stuck?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[may13]

TRIGGERING THIS NOTIFICATION VIA FLOW

 YES ONCE APPROVAL REJECTED WE NEED TO SEND NOTIFICATION AND THAT NOTIFICATION WE NEED TO SHOW REJECETED PERSON NAME BUT MAIN THING IS WE NEED TO CREATE THIS NOTIFICATION IN SN_HR_CORE_CASE TABLE