Skip to main content
Nintex Community Menu Bar
Question

Check for existing value in a collection

  • January 11, 2024
  • 2 replies
  • 84 views

Forum|alt.badge.img+1

 

We have a library we will register project documents.  We create a workflow to check if the projectcode that the user enters exists.
Therefore we perform a collection operation with the exist action on a list on another site. 

The projectcodes in  source list consists of 2 letters, a space and 2 or 3 digits, ie [aa 123].

In the workflow we query to list to get a collection. In the next action we perform a collection operation to see if the projectcode the user entered  exists in this collection.

It turns out that the collection operation exist never returns a “ true”  result.

On a list with no spaces the exist operation works as expected.

How can we use the collection operation on a collection with spaces?  And is this a bug or feature?

2 replies

SimonMuntz
Nintex Employee
Forum|alt.badge.img+23
  • Nintex Employee
  • January 15, 2024

Hi @AlfredBoeren,

Based on your description, I tested this functionality and had no issues with spaces in the codes.
What is the column type on the source list that has the codes?
What is the column type on the document library that has the code?
I used Single lines of text columns in my test.


Forum|alt.badge.img+1
  • Author
  • Rookie
  • January 15, 2024

Hi Simon,

Both fields are Single line text fields.

The source list contains 87 items.

A  test with a list containing 10 items, did give a result. So it seems the number of items causes the problem. Maybe the total characters in the collection cann’t exceed 256?