Nintex Connect

Hello

 I have a multi choice selection box in infopath.  From the choices selected I need to query a secondary list to get corresponding email addresses and build a string so that this variable can be used in the To: field of the workflow notification.

 So far I have created an SitesAffectedCollection and queries the list to get the values selected.

I then have a For Each loops through each item in the SitesAffectedCollection and then Query that queries the secondary list and brings back the corresponding email address.  Should I store these values in another Collection?

I need to then build a dynamic string so that it concats each email into a string, seperating the values by a semicolon.

HELP (ps I am not a developer by any stretch so I'm sorry if the answer is obvious!)

Hi Natasha,

Create yourself a text variable (something like textEmailAddresses).

As you are using a For Each action to go through the collection, run your query and then have a Build String action that does the concatenation for you.

Your Build String action would look something like this in the configuration:

{WorkflowVariable:textEmailAddresses};{WorkflowVariable:textNewEmailAddress}

and store the result back in the textEmailAddresses variable.

What this is doing, is appending a semi-colon and the new email address to the existing variable.