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?
Solved! Go to 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
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
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,
Power Apps User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.
Did you miss the call?? Check out the Power Apps Community Call here!
User | Count |
---|---|
269 | |
209 | |
76 | |
43 | |
36 |
User | Count |
---|---|
347 | |
225 | |
118 | |
72 | |
54 |