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

ComboBox

Hi guys,

 Need some help please. I have an Excel workbook with around 7000 rows. When i create a combobox for one of the columns, the drop down menu shows me like a few hundered records i think. Is there a limitation here ? or is there any formula that i need to input to see all the values ? 

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Re: ComboBox

You might have an issue with Delegation.

 

Links:

https://docs.microsoft.com/en-us/powerapps/delegation-overview

https://blog.coeo.com/davidmorrison/2017/06/21/powerapps-500-record-limit-delegation-and-how-to-work...

https://powerusers.microsoft.com/t5/PowerApps-Ideas/Fix-500-Record-Limitation/idi-p/38490

 

tl;dr For some functions, only the first 500 rows are returned. That's a known issue and I don't think it has been solved before. In any case, if you want to use more than 500 records, you would have to limit yourself to using delegable functions.

 

Edit. Added another link.

7 REPLIES 7
PowerApps Staff Jeremy_Rodgers
PowerApps Staff

Re: ComboBox

Hi Babalaul,

I have tried this today with a 10000 row Excel table and I was able to see all of the rows in the combobox drop-down.  There should not be a limitation to how many rows you can display, Items property should be set to the name of the Excel table.  It's possible there is something in the data that is causing an issue.  If you can share the Excel file with me I can have a look.

 

Thanks,

Jeremy

Anonymous
Not applicable

Re: ComboBox

You might have an issue with Delegation.

 

Links:

https://docs.microsoft.com/en-us/powerapps/delegation-overview

https://blog.coeo.com/davidmorrison/2017/06/21/powerapps-500-record-limit-delegation-and-how-to-work...

https://powerusers.microsoft.com/t5/PowerApps-Ideas/Fix-500-Record-Limitation/idi-p/38490

 

tl;dr For some functions, only the first 500 rows are returned. That's a known issue and I don't think it has been solved before. In any case, if you want to use more than 500 records, you would have to limit yourself to using delegable functions.

 

Edit. Added another link.

Babalaul
Level: Powered On

Re: ComboBox

Thank you

Babalaul
Level: Powered On

Re: ComboBox

I will try to sort out data again and see if that will help. 

Anonymous
Not applicable

Re: ComboBox

Again, I don't know about the specifics of your problem but if it's a problem with delegation, the issue would be with the formulas, not the actual data. Just so you know.

JRaasumaa
Level 10

Re: ComboBox


@Anonymous wrote:

You might have an issue with Delegation.

 

Links:

https://docs.microsoft.com/en-us/powerapps/delegation-overview

https://blog.coeo.com/davidmorrison/2017/06/21/powerapps-500-record-limit-delegation-and-how-to-work-around-it

https://powerusers.microsoft.com/t5/PowerApps-Ideas/Fix-500-Record-Limitation/idi-p/38490

 

tl;dr For some functions, only the first 500 rows are returned. That's a known issue and I don't think it has been solved before. In any case, if you want to use more than 500 records, you would have to limit yourself to using delegable functions.

 

Edit. Added another link.


 

Based on the list of actual delegable sources it seems excel isn't in the list.

 

https://docs.microsoft.com/en-us/powerapps/delegation-list

 

I'd say that's definitely the issue here. Nice work!

ttwydi
Level: Powered On

Re: ComboBox

Hi,

I have the same issue but using a Sharepoint List, for which I thought the combobox items were delegable. Instead I only get the first 500 hundred employees from my list in my combobox. I understand I could raise that to 2000, but I need to go above that.

 

I just put the formula Items = Employees, with Employees the name of my sharepoint list.

 

What am I missing?

 

Thanks,

Jerome

Helpful resources

Announcements
firstImage

PowerApps Monthly Community Call!

Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.

firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

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

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 190 members 5,364 guests
Please welcome our newest community members: