Approval based on choice table selection

[Cat]

Hi all,

I have a requirement to get 2 approvals based on a selection on a table. Each selection requires two different (named) users to approve it.

How can I get this to work? Generally approvals ask for specific approvers in groups, but that would be right in this case as it depends specifically on what they choose.

Thanks,

Cat

[Ankur Bawiskar]

@Cat 

you can use scripted approval in flow

check this

Scripted Approvals in Flow Designer with Flow Variables 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Tanushree Maiti]

Hi Cat ,

Here assumption is that your custom lookup table has these 2 fields (e.g u_approver1, u_approver1) that reference the user(sys_user) table.

1. Create the Flow: Trigger the flow on Catalog Item submission.
2. Get Catalog Variables: Fetch the user's selection from the form.
3. Look Up Record: Use the Look Up Record action to find the row in your custom table that matches the user's selection.
4. Ask for Approval: Add the Ask for Approval action.
   • In the Approver field, drag the data pills for u_approver1 and u_approver2 from the Look Up Record step.
   • Set the approval rule to Everyone must approve.