Power Platform Community Forum Thread Details

Not sure if this helps anyone but I found that trying to search a multiperson column only worked when I typed the full name in my text input. Partial entry worked fine in a single person column. My solution was to switch to Filter(ThatDataSource, TextInputBrowseSearch.Text in Concat(YourPeopleColumn.DisplayName, DisplayName)) instead of just Filter(ThatDataSource, TextInputBrowseSearch.Text in YourPeopleColumn.DisplayName). Now I just need to enter part of their name for it to filter correctly.

Categories:

Building Power Apps

@catpigeon1924

Yep...that's the way to do it!!

It does not make a difference in this case because you're dealing with people names (although it might in some cases), but a slight tweak to your formula would be:

Filter(ThatDataSource, 
 TextInputBrowseSearch.Text in Concat(YourPeopleColumn.DisplayName, DisplayName & "|")
)

The distinction is this...if your multi person column has two names in it:

Bill Davis and Onan Mourad

Then if someone is searching for Davison, then you will return this record as well.

Reason is because the result of your concat would be: Bill DavisOnan Mourad

And, as you can see, Davison is in that string. So adding the vertical pipe in this case, will separate the names and not result in a false result. Bill Davis|Onan Mourad

Which would not return from a search for Davison.