AnsweredAssumed Answered

O365 Query List with filter on Person field

Question asked by s.devalk on Feb 9, 2015
Latest reply on Feb 13, 2015 by s.devalk

Hi there

 

When using the Nintex Workflow for O365 "O365 Query List" action there is an option to filter a list on a field. The field I would like to filter on is a 'Person' field. The XML return of the query contains the User ID like this:

"

<MetaDataCollection xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

  <MetaData>

    <Key>Employee</Key>

    <User>

      <FieldUserValue>

        <LookupId>28</LookupId>

      </FieldUserValue>

    </User>

  </MetaData>

</MetaDataCollection>

"

When trying to match the LookupId value to a different Person field 'User ID Number' or an instantiated variable containing only the 'User ID Number' the query returns no results. What should I do to make the filter work?

Outcomes