cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Oskarkuus
Super User
Super User

Dropdown - hide items untill searching

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?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
RezaDorrani
Dual Super User
Dual Super User

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

 

 

View solution in original post

5 REPLIES 5
RezaDorrani
Dual Super User
Dual Super User

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
Community Support
Community Support

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Awesome!

 

This is what im looking for, Thanks reza!

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

To update sharepoint people picker.  Use this.

 

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

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,715)