have a look on this - https://community.nintex.com/message/71985-re-query-and-filter-list-if-criteria-is-included-in-colletion-output?commentI… 

I can't get this to work - my ValuesList variable prints out to this:

error is 'Failed to query list data. Value does not fall within the

expected range.

I changed the string builder to remove the last, empty Value tag and

receive the same error.

I'm getting the list of users by querying the list in question, setting the

person/group field to a collection variable , say col1 - then I loop

through col1 for each result, currentUser, add the currentUser to a new

collection col2. col2 is what is being referenced in the build string for

the ValuesList

could you post a sample what output do you get from build string action?

resp. how does your overall query list action look like afterwards.

Strange, the email response stripped that part out.  This is the result of the build string

<Value Type='User'>i:0#w|aesp555555555.ctr</Value><Value Type='User'></Value>

I figured it out - I hadn't noticed that in the query list action you have to deselect xml encode.  So now I don't get an error, but the filter isn't working - my query is returning 0 items when i know that isn't true. I tried removing the empty value tag at the end (which is needed for multi values so this couldn't be a fix regardless) but that didn't make a difference

My caml query is

<Query>

<Lists>

<List ID="{555E5F55-5555-5ED-55E-555555555}"/>

</Lists>

<ViewFields>

   <FieldRef Name="ID"/>

</ViewFields>

<Where>

<In>

<FieldRef Name="SystemOwner"/>

<Values>{WorkflowVariable:ValuesList}</Values>

</In>

</Where>

</Query>

(obvi not the real list id, i typed this manually and didn't want to bother copying the real id)

What's your person or group field setting for 'Show field'?

if you use default 'Name with presence' then you should provide into the filter either user IDs ...

.... or user display names ...

... just like you did for person field with single entry.

I did end up getting this to work!  I take the current multi person field and save the ID as user Id - Number.  Then the where clause in CAML is 

<Eq>

   <FieldRef Name='SystemOwner' LookupId='True'/>

      <Value Type='UserMulti'>{WorkflowVariable:idVar}</Value>

</Eq>

Thanks for working with me on this, Marian

great!

please select and mark a correct answer to close the thread.