Create alternative collection in Nintex Workflow?

  • 23 September 2022
  • 2 replies
  • 7 views

Badge +4

I've got a workflow which uses a query action to create a collection. but sometimes I would like to run a alternative set of values through the workflow in the same collection. 

If I use the add item to collection action it adds quotation marks, which I can't easily remove with a regex action. I choose text and add 69384,68825,68808 the output is: ["69384,68825,68808"]

 

Can someone tell me how to manually add a set of items to a collection with the least amount of work?


2 replies

Userlevel 6
Badge +16

Hi @EricV 


 


Just use a List to store your values. Then Query that List


 


Step 1. Create your List. Very straightforward. 
Decide the type of values which you want in your list. 
Below is a list of Fruits.



Step 2: In your workflow. add a Query List action. configure as follows


List: Your list name


Filter: Set your filtering. I take all 12 fruit items


Sort: Set your sorting. I use filter by Title


Output Type: Select separate output per column (needed to create a collection)


Select the column "Title" and provide a Collection variable to store the output



 


Output:


Use a Log to History to display the collection


["Apple","Banana","Cherry","Grape","Lemon","Lime","Mango","Orange","Papaya","Peach","Pear","Strawberry"]

 


 

Badge +4

Hi Garret, thank you. Not really the solution I hoped for, cause this takes quite some time to setup for each custom run. The original solution also works like this. I hoped for an option to insert the values directly in a workflow action like "set variable".

Reply