Search with People picker and string in gallery

[Ashok2]

Hi All 

Is there a way we can search in gallery from both column type people picker and String ?

[zmansuri]

It's not possible to directly search on people picker that's why you use AddColumn function in the code. So let's say you have people column named "Employee". And one text column named "Name". your code will be

Search(AddColumn(ListName,"EmpText",Employee.DisplayName),TextInput.Text,"EmpText","Name")

Above code will dynamically add column named EmpText in your gallery and search on it.

[v-chenzhi · Accepted solution]

Hi @Ashok2 ,

May I ask what the gallery's data source is? Is it a SharePoint list?

I did a test on my side in SharePoint.

I create a list named Test and add two columns.

Set the Gallery's items property to:

Filter(Test,Or(Person1.DisplayName in TextInput.Text,Text1 in TextInput.Text))

For example, I add those record in sharepoint.

In canvas, I write test3 in TextInput, Then two test3 of different data types are displayed in the gallery.

         

Best Regards,

Zhi Chen