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 / How to search a column...
Power Apps
Unanswered

How to search a column that contains multiple Persons / Office 365 Users?

(0) ShareShare
ReportReport
Posted on by 4

Hi everyone,

I need some help figuring this out, I have data like this:

TeamList:


TeamnameProductOwnerScrummasterteammembers
Team aJohnPeteNoah Oliver Charlotte Amelia James Ava
Team bMaryJamesEmma Oliver Charlotte Elijah James Ava
Team cJoeOliviaCharlotte Elijah Amelia James
Team dScarletEmmaOliver Elijah Amelia Ava

All the names in my data are actual office 365 users, so not text. This prevents me from searching them in a column like this (or filtering):

Search(TeamList, SearchInputField.Text, teammembers)

Does anyone have any ideas on how I can solve this? For example by telling me how I can convert the teammembers column to a new column that transforms the Persons to actual text I can filter/search?

Thanks in advance!

Categories:
I have the same question (0)
  • Tolu_Victor Profile Picture
    197 Super User 2024 Season 1 on at

    Hi 
    Is this a dataverse table. 

    Try using a filter function instead

    Filter(TeamList, SearchInputField.Text in teammembers.Fullname)

     

    -------------------------------------------------------------------------
    If I have answered your question, please mark your post as Solved.
    If you like my response, please give it a Thumbs Up.

  • Gorilla_8 Profile Picture
    on at

    Hi @CvP , have you try this solution>

    Solved: Filtering current user in a multi-person column - Power Platform Community (microsoft.com)


    If I help or solved your problem, please accept as soluiton and give me kudos! Thanks

  • CvP Profile Picture
    4 on at

    Sorry, forgot to mention, it's a sharepoint list.

    And this:

    Filter(TeamList, SearchInputField.Text in teammembers.Fullname)

    doesn't work, because teammembers contains multiple people, so there is not a .Fullname property on the group.

  • CvP Profile Picture
    4 on at

    I already tried that, but I gave it another shot.

    So this works:

    Filter(TeamList, SearchInputField.Text in ShowColumns(teammembers, "DisplayName")


    The problem is, this only works if I put in the entire name of someone. And I either want to filter using a dropdown containing all the people, or use an input where people can type in part of the name.

    Any other suggestions would be appreciated!

  • Tolu_Victor Profile Picture
    197 Super User 2024 Season 1 on at

    So what you can do is  create a column that stored all names as comma-separated text. Use the AddColumns and Concat function for this

    Filter(TeamList, SearchInputField.Text in ShowColumns(AddColumns(teammembers,"joinedNames",Concat(DisplayName,Value,", ")), "joinedNames")

     

    Note you might need to tweak it a little as I don't fully know your table schema but that is the general idea.

  • WarrenBelz Profile Picture
    155,752 Most Valuable Professional on at

    Hi @CvP ,

    @Tolu_Victor's solution is close - just left out list and field names in the positions required. A couple of other things - get rid of the Delegation warning (you have not solved the limitation - just masked it, but OK if your list is under your limit). Also allow for the search box to be empty

    If(
     Len(SearchInputField) > 0,
     With(
     {
     wTeam: 
     AddColumns(
     TeamList,
     "Member",
     Concat(
     teammembers,
     DisplayName
     )
     )
     },
     Filter(
     wTeam,
     SearchInputField.Text in Member
     )
     )
    )

     

    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

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 483

#2
WarrenBelz Profile Picture

WarrenBelz 399 Most Valuable Professional

#3
11manish Profile Picture

11manish 327

Last 30 days Overall leaderboard