Office365Users.SearchUser field to search in?

(0) Share

Report

Posted on by Kubo

Hello,

I have simple gallery people picker, this is in the gallery item property:

Office365Users.SearchUser({searchTerm: TextInput1.Text})

Is there way to select which field is searched (like email or displayname)? You can do this with combobox but I cannot figure it out with gallery. I have tried Office365Users.SearchUser({searchTerm: TextInput1.Text}).DisplayName for example but that did not work.

Thank you in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Kubo :

Do you want to filter on the "email" field or the "displayname" field based on the user's choice?

If so,please try:

1\Add a Radio control(Radio1) and set it's items property to

["Email","Displayname"]

2\Set the Gallery's items property to:

With( {UserList: Office365Users.SearchUser({top:999})}, Switch( Radio1.Selected.Value, "Email", Filter( UserList, TextInput1.Text in Mail ), "Displayname", Filter( UserList, TextInput1.Text in DisplayName ) ) )

Best Regards,

Bof

Was this reply helpful? Yes No
Kubo 61 on at

Like (0)

Report
Copy link

Link copied!
Thank you very much for your reply. I have tested it and it did not work for me although no errors were shown. There is probably to many users to search this way. I know there is some limit to search user function, this return results:
Office365Users.SearchUser({searchTerm: TextInput1.Text})
this does not return results:
Office365Users.SearchUser({searchTerm: TextInput1.Text in Mail})

In Combobox you can select search field, would there be any way to select the search field in the Gallery?

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Kubo :

The second formula you provided has a syntax error, SearchUser does not allow you to search in this way.

If you need to user gallery to select the search field,please try:

1\Add a Gallery control(Gallery1) and set it's items property to

["Email","Displayname"]

2\Add an other gallery and set it's items property to:

With( {UserList: Office365Users.SearchUser({searchTerm:TextInput1.Text,top:999})}, Switch( Gallery1.Selected.Value, "Email", Filter( UserList, TextInput1.Text in Mail ), "Displayname", Filter( UserList, TextInput1.Text in DisplayName ) ) )

Best Regards,

Bof

Was this reply helpful? Yes No