cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Nintex Newbie

Add to Collection Variable from Lookup column

Jump to solution

My workflow assigns a Flexi-task to an employee who responds by indicating on the task form which document have gaps and which do not.  The form uses two lookup columns from the list item to store the selections. 

Flexi-task form.jpg

The task assignee may select 1 or more documents in the CCBGDs with Gaps and CCBGDs with no Gaps fields, or may leave either of these fields blank. 

Selections.jpg

 Here's how I configured the Collection operation action:

Collection operation.jpg

 

I want the workflow to add the numbers in these fields, T1111 and T1112 in this example, to a collection variable that will be used to query another list and pull data.  I verified by having the workflow log the count for my collection variable and it is treating both numbers as one item instead of 2.  How do I get the workflow to recognize these numbers as separate data points?

 

 

Labels: (1)
Tags (1)
0 Kudos
Reply
3 Replies
Highlighted
Nintex Employee
Nintex Employee

Re: Add to Collection Variable from Lookup column

Jump to solution

@PEnstrom You will most likely need to do a regular expression(https://help.nintex.com/en-US/nintex2016/4.5.1/#cshid=NintexWorkflowRegularExpression) on the value of the field to split it multiple values. You will then need to extract the values from the collection and add it to the existing collection.

View solution in original post

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Add to Collection Variable from Lookup column

Jump to solution

I added the regular expression actions that split the data from the column, then extract it to the Gaps collection variable.  The workflow messages show that T1111 and T1112 are split, but the message from the extract expression shows 4 ;'s but not the actual data.  However, the collection operation that counts items in the Gaps collection variable counts correctly as 2 items.

Workflow history.jpg

 

 

 

 

 

 

 

 

 

 

The regular expression actions are configured as below:

Splitting data from list column.jpgExtracting date and adding to Gaps collection variable.jpg

Is my syntax incorrect for the extract regular expression?  Are these actions treating the separating ; as part of the data?

 

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Add to Collection Variable from Lookup column

Jump to solution

I solved by syntax problem in the regular expression by using \w+(?=\;)

0 Kudos
Reply