I have looked at many posts but just can't seem to get there. I have a Form that has multiple checkboxes for branches.
The requirements are for the workflow that it will only send to those folks at those branches and not all.
I created a Sharepoint list to pull the information from
In the Workflow (based on other posts) I created two collection variables
Then I created a query filtering by Branches
If they select "All Branches" it will send to everyone listed no issues.
If they select just Atlanta it works
If they select Atlanta, Dallas it errors and gives this error
Because I like to try everything I did try to create a group to put in place of the individual emails and same thing happens. It will work for the one but not if several are selected which is what I need.
HELP! I feel I am so close!
I am using on Prem Nintex Forms and Workflows 2013
I tried that and it didn't work. I even put another column in with single text field and put the email addresses with ; and space between and tried the contains and is equal to and it errors.
If only 1 tick box is selected the result would be "All Branches" and the list query works as it finds "All Branches" in a single record
If multiple boxes are ticked the results would be "Atlanta, Miami" and the list query can't find any records that match that exactly (as you have atlanda, and miami in separate lines.
So you'll need to first parse the branches selection using a regex, spiting on "," and storing in a collection
then you do a for loop on the collection (it will run once for each branch (create a text variable) found in Branches)
Then in the loop add the query record updating to use the variable "branches" to query with and send the email