How limit Dropdown choices People picker field option until SearchText is blank

(0) Share

Report

Posted on by vinay14sep

Hi,

I've a Dropdown choices People picker field in a Form connected to sharepoint list Person type column.

I want to restrict the dropdown options (as it bringing up all the cache names in the drop-down list).

Once the user starts typing name in the DropDown type field, the search can begin and start showing the search results in the dropdown list.

Here are few info:

NewForm:

Newform (after clicking Combobox):

DataCard info

Data Feild :

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@vinay14sep - One option is to add a Text Input Control into your app, and then filter the Combo Box control or Dropdown control results based on whatever is entered in the Text input control.

For example add the Office 365 Users connector into your app, and then add the following into the Items property of the Combo Box/Dropdown:

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

And add the following into the DisplayMode property of the Combo Box / Dropdown. This will prevent users from selecting the seeing cached records.

If( Len(TextInput1.Text) = 0, DisplayMode.Disabled, DisplayMode.Edit )

Was this reply helpful? Yes No
vinay14sep 13 on at

Like
a
(0)

Report
Copy link

Link copied!
@Amik , thanks for response.

I did try it out.
The user experince is bit differnt when using an additional Text Input. + we still have to click Drop down box to look at the search results and select. (+hiding away this additional text box after use)

However, I could find an alternate solution :

Items property of Combo Box (DataCardValue23_3):
Filter( Office365Users.SearchUserV2( { searchTerm: Trim(Self.SearchText), isSearchTermRequired: true } ).value, AccountEnabled = true )
Critical is to set "isSearchTermRequired" as true.

and the Update property of DataCard to be :
{ Claims: "i:0#.f|membership|" & Lower(DataCardValue23_3.Selected.Mail), DisplayName: DataCardValue23_3.Selected.DisplayName, Email: DataCardValue23_3.Selected.Mail, Department: DataCardValue23_3.Selected.Department, JobTitle: DataCardValue23_3.Selected.JobTitle, Picture: "" }

It worked for now, dont know how efficient this is.

please let me know your thoughts.

Was this reply helpful? Yes No
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@vinay14sep looks fine to me. Glad you found a solution.

Was this reply helpful? Yes No