Search person or group field in powerapps

Like (0) Share

Report

Posted on 18 Sep 2020 09:41:22 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

I have the same question (0)

All responses (5)

Answers (1)

iampegram 11 on 22 Feb 2022 at 19:14:24

Like (2)

Report
Re: Search person or group field in powerapps

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
infamouslysin 14 on 20 Mar 2021 at 19:02:07

Like (0)

Report

Re: Search person or group field in powerapps

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
v-yutliu-msft on 21 Sep 2020 at 08:11:42

Like (0)

Report

Re: Search person or group field in powerapps

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
marial16 443 on 21 Sep 2020 at 08:09:41

Like (0)

Report

Re: Search person or group field in powerapps

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

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft on 21 Sep 2020 at 08:05:56

Like (3)

Report
Re: Search person or group field in powerapps

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