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.

View solution in original post

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.

View solution in original post

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
thirdimage

Power Automate 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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

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