Unanswered

Working with 5000+ records in Combo Box

(0) Share

Report

Posted on by MustafaHussain

173

Hi,

I have a sql table of Employees with over 5000+ records and I want the user to search in a Combo box and pick that particular employee in that Combo Box

I am using SQL and a Table has a Unique Identifier (ID) as a Primary Column which is a Auto Generated Column too.

I am getting Delegation issues can anyone help?
@WarrenBelz @RandyHayes @mdevaney
@eka24

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

mmollet 3,187 on at

Like (0)

Report

Max items in a combobox by default in PowerApps is 500 so keep that in mine. The only way around this that I know of is using the search function to access more items. I would say try to filter out as much as you cas as anything over a few hunder items is a bit overkill by most standards. The other option is that you could always build a gallery to function as a dropdown/combobox and that will allow you to show however many you need. This would have to be custom built but should be very easy to handle doing so.

If you can filter down to less than 500 this would be your quickest solution I would imagine. I dont know your scenario so I'm not sure how to help you with the filter idea.

Was this reply helpful? Yes No
MustafaHussain 173 on at

Like (0)

Report
@mmollet

A user will search in combo box by employee name or email ID and then select that employee in combo box

right now I am using this
Filter(Employees,StartsWith(EmpFullName,ComboBox1.SearchText))

1 people found this reply helpful.

Was this reply helpful? Yes No
mmollet 3,187 on at

Like (1)

Report

You could do the same thing but use a gallery as I mentioned. Would take maybe 10 minutes to build your own combobox given that its a single select combobox. This would let you display as many results as you want and you can still add a search bar/text input that will help filter just like a real combobox.

Was this reply helpful? Yes No
MustafaHussain 173 on at

Like (0)

Report

@mmollet

I appreciate that but the thing is the client has confirmed the UI to use Combo Box not a separate textinput and a gallery.

will this formula work?

Was this reply helpful? Yes No
mmollet 3,187 on at

Like (1)

Report

Im not sure how to fix the issue then unfortunately. You either have to find a way to filter down to below 500 items or try some formulas using the search function. Not sure if going over the 500 limit is possible or not.

Was this reply helpful? Yes No
timl 36,393 Super User 2025 Season 2 on at

Like (1)

Report

@MustH

You should be able to do this without any delegation issues by setting the Items property of the Combobox to Employees.

You would then specify the employee and email id fields in the SearchFields property of the Combobox.

Was this reply helpful? Yes No
WarrenBelz 153,073 Most Valuable Professional on at

Like (0)

Report

@MustH ,

This blog of mine may also be an option.

Was this reply helpful? Yes No