Send to Multiple Email Address(es) based on selected check boxes and querying a SharePoint List

3 years ago
21 October 2020
9 replies
36 views

carriecalvi
26 replies

Hello All,

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

9 replies

Are you separating the resulting email addresses with a semicolon and a space?

It is using a Person or Group Type Column so it does that automatically.

Another possibility is that there is an issue with the separator in the Branches field/column itself... possibly within the Query List filter.
-or-
Have you tried Branch Location |contains| Branches?

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