ComboBox and DropDown only allow a maximum of 800 items

Like (1) Share

Report

Posted on 1 Mar 2024 12:26:41 by CU17011032-0

Hi.

I have a Canvas App Page inside a Model-Driven App Solution. I have a function as follows:

ClearCollect(SitesDropdown, SortByColumns(ForAll(Sites, {SiteId:Site ,Position: Value(SiteCode), SiteCode: SiteCode, Description: SiteCode & " - " & Name}),"Position",SortOrder.Ascending));

This has 807 entries, but I am only seeing 800. My Settings has been updated to allow 2000. I have no idea what is causing this as when I view the Collection by clicking on it it has all 807 records. I messed about with screen size and this definitely has an impact on what is displayed.

Can anyone help?

Thanks.

John.

Categories:

General Questions

I have the same question (0)

All responses (2)

Answers (0)

apihut 20 on 25 May 2024 at 01:43:02

Like (2)

Report

Re: ComboBox and DropDown only allow a maximum of 800 items

I noticed this limit of 800 in the Modern Combobox. It's not driven by the app data row limit. The tricks with:
- Filter( MyTable , cbx_comboboxname.SearchText in MyColumn ) or
- Search( MyTable , cbx_comboboxname.SearchText , MyColumn ) did help with search in the Modern Combobox but the items beyond the 800 that did show up in the dropdown were unselectable/unclickable.

Switching to Classic Combobox helped. It doesn't look as nice but it does the trick. The entire table.column (in my case 3,600 items) is searchable and selectable.

Was this reply helpful? Yes No
cdwhite 1,067 Most Valuable Professional on 01 Mar 2024 at 13:14:11

Like (2)

Report

Re: ComboBox and DropDown only allow a maximum of 800 items

Hi @johnguilbert191 ,

This is a limitation with the modern controls used in custom pages. This is the same experience for the modern drop down control in standalone canvas apps.

2 options:

1) open a standalone canvas app. Add a classic dropdown control. Copy & paste it into your custom page,
or
2) consider open source component libraries, such as this one from Luise Freese & Robin Rosengrun

------------------------------------------------------------------------------------------------------------------------------
If I've answered your question, please mark your post as Solved. You can accept more than one post as a solution.

If my response was a good one, please give it a Thumbs Up!

Visit my blog: https://platformsofpower.net

Was this reply helpful? Yes No