Skip to main content
Nintex Community Menu Bar

I am using Sharepoint/ Nintex 2013.  I have a list with 12 items.  It's named List A.  I am only interested in one column, the Daily Rate.

21756iBB93FA2357A7A0AA.png

I wish to extract a variable number of items between 1 and 12. So I am using Query List with a Collection variable called vCollItems.  Since the item limit is variable, I am using a Number type variable called itemLimit.

 

21757i41798CCA73630DA0.png

 

The Query List configuration says:  Use List A, select all records, don't filter them, extract the variable Item Limit number of records, and store the in the collection variable.

 

21758i26E5EE84D71FEB69.png

When I go to run the query I see the following:

21759iFE98983215774C26.png

 

After I run the query I get the following result:

21760iDFAD76EEBAFC90CE.png

 

If I enter an actual number in the Item Limit field, the query returns the correct results.

21761i2FBCAA6F8B084F82.png

 

Has anyone seen this behavior?  Any ideas on how to fix this?

Thanks for any help you can provide.

Pat

As you defined the item limit as a variable which is empty at the time you click the execute query button, an error message is shown that the result cannot be limited as the value isn´t defined. But if you replace the empty variable string {WorkflowVariable:ItemLimit} through a valid value like a number, then it works as expected. This behaviour is just within the action to execute the query. This shouldn´t appear when you start the workflow and set the number of items to limit.

Reply


Sidebar Buttons
Nintex Community Home Contact Nintex Support Check Nintex Status
Terms & ConditionsCookie settings