I have to set up a Nintex workflow that will check the value (drop-down) in the Nintex form and based on that value, CC a specific group(s) of people that are currently in an excel spreadsheet. I plan to create SharePoint groups from the spreadsheet, and there will be more than 20 of them. The field selector is for the location that the form is filled out for, and the contents of the form must be sent to specific people in charge of that location.
The workflow will run when the submit button is clicked on the form. The workflow will need to dynamically use the location selected from drop-down to match it up with a set of groups to be CC'd on the generated email. What's the best way to approach this?
I'm also open to other alternatives to SharePoint groups - maybe distribution lists and anything that you see as a simpler route. I will have more than one SharePoint group/set of people CC'd per each location.