Unanswered

Search value filtering by User from sharepoint Person column

(0) Share

Report

Posted on by Antonioclk

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

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (0)

Report
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

Was this reply helpful? Yes No
Antonioclk on at

Like (0)

Report

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 😞

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report
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")

Was this reply helpful? Yes No