Unanswered

So I have a People or Group Column that allows for multiple selections. I can't seem to filter the gallery based on the fact there is more than one person possibly selected.

(0) Share

Report

Posted on by WhiskyPatrick

When I have a column that only allows one person, the filter in the gallery works. I have done this multiple times, but that solution will not work when more than one can be selected. I've tested that theory by selecting more than one person allowed in a column (which was originally set to only one person or group) breaking the ability to filter (errors). I can then reset that same column to a single selection and refresh the data source, and it works again. I've done this with sever columns of this type.

Filter('My People Column',
StartsWith('Project Manager'.DisplayName, txtPerson.Text)
)

When I change the column to a multi-selection column then the StartsWith section just says it has some invalid arguments.

Thank you

Patrick

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Rajkumar_M 3,741 Super User 2025 Season 2 on at

Like (0)

Report

Hi

Try this

Filter('My People Column', txtPerson.Text in 'Project Manager'.DisplayName)

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
WhiskyPatrick 4 on at

Like (0)

Report

Thank you for the suggestion but unfortunately that did not work and just gave me the same error.

Was this reply helpful? Yes No
Rajkumar_M 3,741 Super User 2025 Season 2 on at

Like (0)

Report

Try this

Filter('My People Column', txtPerson.Text in Split(DisplayName, "; "))

Thanks!

Was this reply helpful? Yes No
WhiskyPatrick 4 on at

Like (0)

Report

Filter('My People Column', txtPerson.Text in Split(DisplayName, "; "))

Gives these errors...

Was this reply helpful? Yes No