Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

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