Why my combo box not showing all the records

(0) Share

Report

Posted on by MIA27

I am developing power app in Teams.

I have collection which i have put on screen visible.

Total records of that collection is 5508 at current, which will growing an average to 15 records per day.

I have combo box whose item property is as below

Distinct(colAllList, Serial).Value

the drop down of the combo box works, it shows the record from the first till a certain limit, it does not show all the 5508 records, (as the allow searching is on) even if I type any text to search from that collection, also it does not show.

Dont understand, why like this, if my collection is of 5508, then why not all records showing in the drop down of the combo box and even in the search of the combo box.

Note : Collection has no issue, as a gallery is based on the same collection and its shows 5508 records properly.

Please guide how to to solve this.

Below is the property of combo box and my app setting

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

Verified answer

WarrenBelz 152,847 Most Valuable Professional on at

Like (2)

Report

Re: Why my combo box not showing all the records

Hi @MIA27 ,

Try the process in the blog of mine.

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report
Re: Why my combo box not showing all the records

Thank you for your reply. I read the link, copied the code.
Changed the Aircraft to my Collection Name (having 5508 records)
changed the field name to my one of the field from the collection
But getting the below errror
The code I am using is :

With( { _Start: Filter( colAllList, StartsWith( Serial, Self.SearchText ) ) }, Sort( Distinct( _Start, Serial ), Value ) )

Please guide what correction to be done

Also please note the image of collection name of the same field is different.

I tried to change to cr333_serial as the field name, still the error remain same.
Second when try to type serial it fetch the below list.
This indicates, that I have correctly selected the Field

Was this reply helpful? Yes No
WarrenBelz 152,847 Most Valuable Professional on at

Like (0)

Report

Re: Why my combo box not showing all the records

@MIA27 ,

What type of field is Serial ? It needs to be Text for this to work.

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report

Re: Why my combo box not showing all the records

Further to my reply to your advise, also please note I was trying to debug the code.
Noted that .SearchText properties also not found against Self.
The available one are shown in the image
Below is the image, the properties available are as below :

What I suspect, it is due to the Teams app or what ?.

I have tried to post you via images also for better reference of the issue.
Kindly guide, how to solve this

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report

Re: Why my combo box not showing all the records

It is a text field, Below pls. find the properties of the column in details

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report

Re: Why my combo box not showing all the records

During Google I sound some discussion on the this topic on below thread,
I dont know what can be reason

https://powerusers.microsoft.com/t5/Building-Power-Apps/I-can-t-find-SearchText-property-of-Combobox-in-Power-Apps-of/td-p/883849

Was this reply helpful? Yes No
WarrenBelz 152,847 Most Valuable Professional on at

Like (0)

Report

Re: Why my combo box not showing all the records

@MIA27 ,

Are you using a Classic or Modern control - if Modern, I suggest you revert to Classic as Modern controls are still in preview and can be unstable/inconsistent.

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report

Re: Why my combo box not showing all the records

Please refer to my below images, I have not enable the modern controls

Was this reply helpful? Yes No
WarrenBelz 152,847 Most Valuable Professional on at

Like (0)

Report

Re: Why my combo box not showing all the records

@MIA27 ,

If that is a Classic combo box and you are using the code on the Items, then Self.SearchText is certainly valid, so something is wrong here.

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report

Re: Why my combo box not showing all the records

sorry, I cannot the understand my mistake. The code I am putting on the Item property of the Comb box
As the below image. when after typing self. , there is no option coming up .searchText.

Was this reply helpful? Yes No