Search person or group field in powerapps

(0) Share

Report

Posted on by marial16

443

Hallo,

I was wondering if there is another way to use a search input field for person or group fields instead of creating an additional column in the SharePoint list with the display name as a text field

i use a gallery and filter my list. and i have already used search function but regarding single lone of text fields

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

v-yutliu-msft Microsoft Employee on at

Like (3)

Report
Copy link

Link copied!
Hi @marial16 ,

Do you want to filter based on display name of person or group field?
Two solutions:
1)use search function

Yes, if you use search function, you need to add a column with display name as a text field.

The reason is that search function only works for text type field. Other data type are not supported.

So the formula should be like this:

Search(AddColumns(table,"displayname",personfield.DisplayName), Textinput.Text, "displayname", "field1","field2",...)

2)use filter function

Filter function could work for multiple data type.

If you use this function, you no longer need to add another column.

Formula should be like this:

Filter(table, Textinput.Text in personfield.DisplayName, Textinput.Text in field1, Textinput.Text in field2, ....)

Best regards,

Was this reply helpful? Yes No
marial16 443 on at

Like (0)

Report
Copy link

Link copied!

when you say table you mean the name of the List?

Was this reply helpful? Yes No
v-yutliu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @marial16 ,

Yes, that's right.

You could refer the syntax for these two functions:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup

Best regards,

Was this reply helpful? Yes No
infamouslysin 14 on at

Like (0)

Report
Copy link

Link copied!

I tried your suggestion for the filter function, but now my gallery will only filter based on the first character entered in the text box. When 2 characters are entered it does not return any results in the list even though they should exist.

Was this reply helpful? Yes No
iampegram 11 on at

Like (2)

Report
Copy link

Link copied!
For the Filter function, you need to use the or operator instead of commas:
Filter(table, Textinput.Text in personfield.DisplayName || Textinput.Text in field1 || Textinput.Text in field2 || ....)

Was this reply helpful? Yes No