Question

Check for existing value in a collection

  • 11 January 2024
  • 2 replies
  • 49 views

Badge +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

Userlevel 6
Badge +22

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.

Badge +1

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? 

Reply