Unanswered

Combo box returning only 500 records

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Everyone,

I have a very simple app built to lookup some information from the backend Sharepoint list.

The form should have a drop down/combo box and on selection of the value, the form should bring in all of its relevant data.

The challenge here is, the list is having more than 500 records but the drop down is showing only up to 500 records. I understand that there is a limitation for the drop down box, so when i tried changing it to a combo box, it still returns only 500 records.

The formula that i wrote on the combo box is, Sort('TestList', Title,Ascending)

I don't have any filters/condition on the query. All I want is to return all of the "Title" values stored in the Sharepoint list.

all of the Title values are unique records and it is of a free text field.

Can someone please help me with the above.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

CU24091509-0 417 on at

Like (0)

Report
Copy link

Link copied!

hi @Anonymous Unfortunately SP combo box has some limitations.
If you have less than 2000 values you may try to change the setting from default 500 to 2000.
under file --> settings --> Advanced
And if you have more items then you might have to follow a hacky process as in this post.
https://powerusers.microsoft.com/t5/Building-Power-Apps/Combo-Box-Only-Displaying-500-items/td-p/599883
_________
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
v-yutliu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Combo box does not have the limit for records number.

I think your problem is about delegation limit.

Do you set the combo box's Items to this formula "Sort('TestList', Title,Ascending)"?

Actually, function in this formula is delegate.

That's a little strange...

Please do not forget to turn off the "allow searching" function for combo box.

The reason is that Search() function is not delegate. Turning on this function will lead to delegation warning.

After do this, do you still have delegation warning?

If yes, could you show me the formula that you have this warning?

What's more, you could also try to change delegation limit to 2000 just like @KranthiTupakula recommend.

Best regards,

Was this reply helpful? Yes No