I am trying to do a simple combobox drop down that pulls data from a CDS table. I am just trying to list name columns in the drop down but what happens is the list gets truncated and doesn't show all of the items. What really confuses me is that when I first load up the powerapp or preview it, it won't show all the items in the combobox, sometimes it shows the whole list without changing the function.
Just to clarify, it only shows 25 items when it isn't working and doesn't show the vertical scroll bar. I also can't search for the missing items as well.
What is also very odd is there is one customer that always shows first (Does not start with an A) regardless of the sort function.
I fill other form labels based on the selected item in the combobox and this function works correctly, it is just the combobox list not showing all the items from the table.
The current function I am using is, am i missing something? I thought it would be just this simple if I don't need to filter or use choices.
Sort('Customer Addresses', Name, Ascending)
I also tried this one which gives me the same results, with sometimes not showing the whole list, usually from the first time opening the application as well and having that one customer show up at top of the list (Does not start with A)
SortByColumns('KD Customer Addresses', "cr282_name", Ascending)
