How to get the approver name in flow designer

[anvitha ash]

Hi community 

When user submit the request, it should go for requested for manager approval. 

Now let's say instead of manager approve or reject, some other admin user approves the request, now I need to get the approver name who approved or reject the request in flow designer 

How can we get who approved the request??? 

[jcmings]

You probably would want to do a Look Up Records flow action and look up the specific approval record you're pointing to. From there, you can identify the record that was either Approved or Rejected (versus No Longer Required) and can grab the name from that particular record. It'd either be in the Approver field or potentially the Updated by field.

[Martin Friedel]

Hello,

first of all, admin accounts should not be ever used for doing such action like approving on behalf. For approving on behalf, there is Delegation functionality.

To answer your question:

• Approval records are in Approval table [sysapproval_approver]
• Approval record has update history so it means each record's change is tracked in table History [sys_history_line]
• In flow you can use 'Look Up Record' step with following conditions:
  • Table: sys_history_line
  • Set: <record that was approved/rejected>
  • Field: state
  • Order by: Created, z-a
• Then you get a History record that has in field 'User' reference to person who approved the record.

Approver record:

History record:

If my answer helped you, please mark it as correct and helpful, thank you 👍
Martin