cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
CYT_Dev
Level: Powered On

ComboBox only showing 15 items

Hi,

I have a Combobox that has a Excel table (Table1) as a data source. The table has 1265 rows of data and a column called Brand

I have the data in my combobox set to Distinct(Table1,Brand)

This works, but is only showing the first 15 brands (there are 31).

Any idea why this is?

 

thanks

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: ComboBox only showing 15 items

@CYT_Dev 

The distinct function cannot be delegated so it only looks at the first 500 of 1,265 rows and finds the unique results.

 

You can increase the delegation limit in Advanced settings to 2,000 rows.  In your case this should produce the correct result.

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

1 REPLY 1
Super User
Super User

Re: ComboBox only showing 15 items

@CYT_Dev 

The distinct function cannot be delegated so it only looks at the first 500 of 1,265 rows and finds the unique results.

 

You can increase the delegation limit in Advanced settings to 2,000 rows.  In your case this should produce the correct result.

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,272)