Answered

Does Combo box support infinite scrolling like gallery?

(0) Share

Report

Posted on by rbn_nue

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

Categories:

General Questions

All responses (5)

Answers (1)

rbn_nue on at

Like (1)

Report

Re: Does Combo box support infinite scrolling like gallery?

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.

Thanks
ANB 6,939 on at

Like (0)

Report

Re: Does Combo box support infinite scrolling like gallery?

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

Thanks,
ANB
rbn_nue on at

Like (0)

Report

Re: Does Combo box support infinite scrolling like gallery?

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.

Thanks
Sanshubhs 98 on at

Like (1)

Report

Re: Does Combo box support infinite scrolling like gallery?

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.
Verified answer

ANB 6,939 on at

Like (1)

Report

Re: Does Combo box support infinite scrolling like gallery?

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