Assign Approval to User based off a Value in a Sharepoint List (nested switchcase or If statement?)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-11-2024 08:59 PM
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?