Assign Approval to User based off a Value in a Sharepoint List (nested switchcase or If statement?)

AndersonC
Kilo Contributor

I've been trying to figure this one out and had no luck. Man Sad

 

Context:

 

I have a PowerApp where users submit a report (the data from which is uploaded to a Sharepoint list).

 

When a new list item is added - this triggers an approval flow to the managers.

 

I have a field in the list called "Branch" that is either East or West.

 

I want to assign the approval to manager Bob if Branch = East OR manager Ted if Branch = West.

 

Note that this is a chain approval, so once Bob/Ted approves it, it gets approved down the line by several others.

 

Issue:

 

Is there any way to implement a switch case within the "Assigned to" field of the approval process, or do I have to run parallel branches all the way down based off whether Branch = East/West? I would like to not have to replicate long approval chain branches (this is both tedious and leaves room for error).

 

**I have tried playing with the if statements/dynamic content in this field to no avail.

 

Documentation:

 

Here is an image that shows what is going on - notice how I have to put the switch case before, then replicate the parallel chains all the way down because of having to split into two seperate approvals. Is there anyway I can have a single approval in which the "assigned to" field can be either Bob or Ted based off of the Branch field of the sharepoint list?

0 REPLIES 0