Really struggling to figure out how to implement this.
I have a User list that stores people who will be doing various things within the workflow.
|Name (People Picker)||Department (Lookup Choice)||Role (Choice)|
In my Nintex Form, the user can select multiple departments they think their request will impact
Impacted Department (Lookup Choice - Multiples Allowed)
Assign an approval task to people who are Portfolio Coordinators (Role) in the impacted department(s) selected by the user on the form.
I did a Query List action on the Users list, pulling two columns: the Name column and Department column WHERE Role = "Portfolio Coordinator". It puts this into a Collection variable.
Because the Impacted Department field in the form allows multiple selections, I'm unsure how to assign an approval task to the people whose Department equals one of the Impacted Department selections in the form.
So far I have:
- Converted the selected values from Impacted BSA into a comma-delimited string
- Split the string into a collection using Regular Expression action
- Query List on the Users list using the conditions I outlined above (pull in the Name column and Department column where Role = "Portfolio Coordinator")
And that's as far as I've been able to go. I don't know what to do now with it.
Thanks in advance for your help.
Best answer by satishkumar529View original