Announcements
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
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/UCnGNN3hdlKBOr6PXotskNLAFollow me on Twitter : @rampprakashdBlog : https://microsoftcrmtechie.blogspot.com
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 😞
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 542 Most Valuable Professional
Haque 206
Kalathiya 201 Super User 2026 Season 1
