web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : +LI9m0BOlB1wSmV9lKfA8c
Power Apps - Building Power Apps
Unanswered

Modern Combo box won't search records > 500

Like (1) ShareShare
ReportReport
Posted on 10 Jun 2023 14:09:27 by 293

I am trying to configure a combo box to accept 1000 items. There are now three versions of combo box controls, Old Classic, Modern and Modern Modern (although this is a dropdown so maybe not equivalent). 

My question is: Can I get the Modern combo box to search my items beyond 500

Set up:

  • I have increased my delegation to 2000. My list has ~1200 items sorted alphabetically by code. The codes begin with "a" and go all the way to "y"
  • The collection has two fields "code", "name"
  • I want to start typing the first letters of the "code" and have the search narrow my options
  1. Modern Modern dropdown - If I click into the dropdown the list opens. I can start typing "a" and the second "a" item on the list will be selected. If I continue typing "a", I will move down the list. I had to put in a "clear" button because there was no way to deselect an item. The list is only the first 20 items. I can't even get into the "b"s. This control is a bust, for now anyway.
    KASCHN_1-1686405033665.png

     


     

  2. Modern control. This one is a little better. I can get down to the "l"s and there is nice quick filter as I type. And a tab accepts the selection. I CANNOT get to the "y"s. In this case, I can only get to the 500th item regardless of delegation. I was looking for a property in this control that I could use to filter the list to the value I typed in the control (like SearchText) but there isn't a property here. So this control is a bust.

KASCHN_2-1686405612046.png

  1. Old classic. What a beast! It is difficult to get this control to look congruent with the other controls in model driven app but it seems to have a nice search and even a couple layouts for list display. It's usability is clunky and I am suspicious of its performance on load but I think it is my only option because I can actually get to the "y"s of my list.

KASCHN_3-1686405919251.png

Does anyone have any suggestions for the modern control or am I stuck using the classic?

 

I have the same question (0)
  • developerAJ Profile Picture
    4,288 on 10 Jun 2023 at 16:05:49
    Re: Modern Combo box won't search records > 500

    @KASCHN 

     

    developerAJ_0-1686412929003.png

    if you go to settings general you will see datarowlimit change it to 2000. you will be able to get 2000 items.

     

    but if your datasource is more than 2000 than you can use items of combobox1:Filter(Test,StartsWith(Title,ComboBox1.SearchText))

    Test is my datasorce list, Title is column i want to use for search

    Please click Accept as solution and Thumbs Up. if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

  • KASCHN Profile Picture
    293 on 10 Jun 2023 at 18:08:42
    Re: Modern Combo box won't search records > 500

    Yes, I think I mentioned that in the first bullet point. I did set the delegation to 2000 which is why I could pull all 1200 items. The combo box just won't exceed 500 and 20 (in the case of new modern dropdown)

  • JenniferK Profile Picture
    167 on 06 Sep 2023 at 19:21:02
    Re: Modern Combo box won't search records > 500

    I tried this approach but I ran into some trouble with it, as detailed here. Any idea how to prevent the combo box Items property from resetting after selection?

  • SonyaBurns Profile Picture
    4 on 22 Feb 2024 at 02:53:49
    Re: Modern Combo box won't search records > 500

    I know this was a while ago, but the reason this happens is that when you reference the search text, once you select an item from the list, the search text disappears, which removes the selected item as that option no longer exists. The only workaround I have found is to add a text input control and use that as your search field.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 714 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 419 Super User 2025 Season 2

#3
developerAJ Profile Picture

developerAJ 243

Last 30 days Overall leaderboard