Approval Process Multiple Approvers

Question

We have 4 approval steps based on a multi-select picklist.

Step 1
If multi-select picklist = (A OR B) OR (A & B)
Will go to Approver 1

Step 2
If multi-select picklist = (C OR D OR E) OR (C & D & E)
Will go to Approver 2

Step 3 
If multi-select picklist = (F OR G) OR (F & G)
Will go to Approver 3

Step 4
If multi-select picklist = (H OR I OR J) OR (H & I & J)
Will go to Approver 4

However, since the criteria is based on a multi-select picklist, if User selects A & B & G the record should go first to Step 1 (Approver 1) then it should go to Step 3 (Approver 3) because user included G. Right now it only goes to Step 1 (Approver 1).

Is there a way to achieve this? We need to add a flexibility where the record should also go to other approvers if it includes one of those picklist values.

cropredy · Answer

You will need the following:

Four User lookup fields on your object Approver i, Approver ii, Approver iii and Approver iv
Process Builder (?) or trigger to set the values of Approver i, ii, iii and iv to the set of Approvers 1-2-3-4 based on values in Multiselect picklist (see example below)
Four approval processes 1Step, 2Step, 3Step, and 4Step with entry criteria determined by how many Approver x fields are non null.  The next Approver in 2Step, 3Step, and 4Step after approval at step 1 is defined by the value of the object's Approver ii User lookup field. Similarly, the next approver after step 2 in 3Step and 4Step is defined by the value of the Approver iii User lookup field. And lastly, the next Approver in 4Step after the 3rd step is approved is defined by the value of the object's Approver iv field

Example:

User MSP value is A;F
Approver i = Approver 1
Approver ii = Approver 3
Approver iii = null
Approver iv = null

When submit for Approval is clicked, approval process 2Step is entered and Approver 1 approves first followed by Approver 3

Approval Process Multiple Approvers

One Answer

Add your own answers!

Ask a Question