web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / So I have a People or ...
Power Apps
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) ShareShare
ReportReport
Posted on by 4
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:
I have the same question (0)
  • Rajkumar_M Profile Picture
    3,747 Moderator on at

    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.

  • WhiskyPatrick Profile Picture
    4 on at

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

  • Rajkumar_M Profile Picture
    3,747 Moderator on at

    Try this

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

    Thanks!

  • WhiskyPatrick Profile Picture
    4 on at

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

     

    Gives these errors... 

    WhiskyPatrick_0-1688654424056.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 421

#2
WarrenBelz Profile Picture

WarrenBelz 345 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 278 Super User 2026 Season 1

Last 30 days Overall leaderboard