Hello,
I have abit of an issue that maybe someone could help me out with!
The scenario is i have a multi dropdown field where i have different roles that the requester can choose. Example
Roles:
Reports Reader
Security Operator
Security Reader
Administrator
These different roles require different types of approvals from 3 different positions
Role | Approval 1 | Approval 2 | Approval 3 |
---|---|---|---|
Reports reader | No | No | No |
Security Operator | Yes | No | No |
Security Reader | No | Yes | No |
Administrator | Yes | Yes | Yes |
Now, this works perfectly when only 1 roles is chosen. However the issue im experiencing is when a requester chooses for example Role Security Operator & Security Reader because i want this to trigger the approval for both.
I believe the issue might have to do with the filter when using the lookup
Because it cant use contain and only is. So when multiple roles are select the Roles doesn’t match the custom object anymore.
Has anyone any idea how could solve this in any other way or perhaps im missing something?