Office365Users Combox Search Fname+LName

[BrokenClock]

I'm trying to use a combox as a user selection box, in a user-facing application.

I've currently got "Mail" and "DisplayName" as search fields.

let's say I'm looking for User: Mail=js234@enterprise.com; DisplayName="Smith, John", GivenName="John"

Search terms that return that user:
js2

Smi
John
Smith, Jo

Search terms that should return that user, but don't
Smith Jo

John Smi

Smith John
John Smith


Is there a way to improve search parameters to allow those search terms to work and return this user ?

[WarrenBelz · Accepted solution]

Hi @BrokenClock ,

The Search or in functions require you to have the string you have entered being present (in its entirety) in the target field/s (as per your examples) - you will never get the second list to work.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps