Dropdown - hide items untill searching

[Oskarkuus]

I am using this in a dropdown

'Office365user'.SearchUser({searchTerm:ComboBox2.SearchText})

It works great and i can search for any user in my organisation.

But i want to limit the list and not show hundreds of users... i just want to show a few.

And i dont want the first top names to show when searchbox is empty.... just show when the first character is entered in the search box.

how can i do this?

[RezaDorrani · Accepted solution]

Hi @Oskarkuus 

to limit use

Office365Users.SearchUser({searchTerm: ComboBox2.SearchText, top: 15})

to show only if data exists

If(!IsBlank(Trim(ComboBox2.SearchText)), Office365Users.SearchUser({searchTerm: Trim(ComboBox2.SearchText), top: 15}))

Regards,

Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[v-xida-msft]

Hi @Oskarkuus ,

Do you want to limit the Items within ComboBox control?

Do you want to show items within the ComboBox only when you typed the first character within it?

Based on the needs that you mentioned, I think a Timer control could achieve your needs. I have made a test on my side, please take a try with the following workaround:

Add a Timer control within your app, set the Duration property to following:

1000

set the Repeat property and AutoStart property to following:

true

set the OnTimerEnd property to following:

If(
   IsBlank(ComboBox1.Selected),
   Set(ShowValues, false),
   Set(ShowValues, true)
)

Then within your ComboBox, set the Items property to following:

If(
   ShowValues = true,
   Office365Users.SearchUser({searchTerm:ComboBox1.SearchText,top:20})
)

Please consider take a try with above solution, check if the issue is solved.

Best regards,

[Haki500]

Awesome!

This is what im looking for, Thanks reza!

[Haki500]

Hi @RezaDorrani,

for this, it works fine if the Combobox start from scratch. 

My question is, is there a formula for people picker that link to sharepoint list?

Please advise.

TIA

[Oskarkuus]

To update sharepoint people picker.  Use this.

{
'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: Dropdown1.Selected.Mail,
DisplayName: Dropdown1.Selected.DisplayName,
Email: ""
}