What is the correct way to query a List-User field for a name?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

In the report's filter section, I wish to look for a name in a List-User field. I know the name is in there, but my input, "John Brown" or "Brown, John" is not accepted, the report comes back blank. What is the correct way to input this name by hand in the report's filter?

Photo of Chris

Chris

  • 4,430 Points 4k badge 2x thumb

Posted 3 years ago

  • 0
  • 1
I have not tested this but a probable solution is to make a text formula field by wrapping your list user function with a ToText( ) and then query the text version of the list user field instead.
Photo of Chris

Chris

  • 4,430 Points 4k badge 2x thumb
That works as long as I input an email address. The User List field works the same way. Thank you for your help.