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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Search value filtering...
Power Apps
Unanswered

Search value filtering by User from sharepoint Person column

(0) ShareShare
ReportReport
Posted on by

hello, i'm new to powerapps so my question is surely super noob. I have a gallery which gets data from a sharepoint list. I want to search and filter by user which is stored in a Person column in sharepoint. how to retrieve data from the user? In the row i just do thisitem.user.displayname but what to write in the search(MyList,searchbar.text, ???? ) function? is there a way to transform the sharepoint data in the dataverse data shown as a table in the related pane?
thanks

I have the same question (0)
  • Ram Prakash Duraisamy Profile Picture
    5,593 Super User 2025 Season 2 on at

    Hello @Antonioclk 

     

    You can give a try like below

     

    Search(MyList, searchbar.text in FieldName.DisplayName)
    
    // Here MyList => SharePoint List
    // SearchBar => Text Box Name
    // FieldName => Person Field

     

    Please mark as Answer if it is helpful and provide Kudos


    Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
    Follow me on Twitter : @rampprakashd
    Blog : https://microsoftcrmtechie.blogspot.com

  • Antonioclk Profile Picture
    on at

    hello, thanks for your answer.
    actually this was exactly my first attempt, but it doesn't work. my sharepoint field is User. the error says "Name isn't valid. 'User' isn't recognized.". I can easily search with other fields but not with the one related to the Person column 😞

  • v-qiaqi@microsoft.com Profile Picture
    on at

    Hi @Antonioclk,

    Have your solved your problem?

    Do you want to search the Gallery based on the input within the TextInput?

     

    Actually, the Search() function only supports search text columns, so if you want to search Person column, you could use the AddColumns() to save person column data within a temporary column.

    Search(AddColumns(List,"UserColumn",User.DisplayName),searchbar.Text,"UserColumn")

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard