Announcements
Hi Folks,
I have a combo box which is connected to a data verse table. Search is enabled for the combo box. The number of rows in the table connected to combo box is expected to go more than 2000. In this scenario, if I perform a search, will it return data from only the first 2000 items in the table or from all items?
Any insights?
Thanks
Hi @rbn_nue ,
If you do search on Text datatype column then 2000 from all items because search function is only delegable with Text datatype in Dataverse and once you reach scrolling to 2000 another set of records will come if the search matches.
I hope you have gone through https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/connections/connection-common-data-service#power-apps-delegable-functions-and-operations-for-dataverse
------------------------------------------------------------------------------------------------------------------------------
I hope this helps.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.
Thanks,
ANB
You can achieve this using a collection. Just follow the blog here:-https://www.sharepointeurope.com/overcome-2000-items-limit-using-power-apps-collect-function/
Just create a collection on the OnStart Property of App.
Hi Sanshubhs,
Thanks for the response. I don't want to collect all items in collection in app onstart as the number of items can go more than 100K. It seems search will work on dataverse text fields, so that should fix my issue.
Hi @rbn_nue : Apologies, I tried a repro from my end and for the statement that I mentioned in my response "once you reach scrolling to 2000 another set of records will come if the search matches" is not behaving like gallery.
So, I would suggest you to create a ticket with MS to clarify on the same before implementing on production app. Also, I dont find any official document for the same and .
Also please check this https://powerusers.microsoft.com/t5/Building-Power-Apps/Combobox-limit-on-items-shown/td-p/776489
When I tested from my end (by setting delegation limit to 2), the search returned items which are not shown in combo box earlier. So it does not support the scroll like gallery but as long as search works, it's fine for me.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 350 Super User 2026 Season 2
M Bilal Khan 318
Mohsin Ali 220
