Missing random values in power apps dropdown column from data verse

[KrishR]

Hello Power users,

I have a drop down column that should show values from a data verse column that has around 4k records in it. Everything is working fine until I found something interesting. There are some values missing from the drop down like if it has 1,2,3,4,5 values it displays 1,4,5 with missing 2 and 3. This drop down column if cascaded from another column that is selected before and display values matching that column value.

Any thoughts if I'm missing anything or an idea what's the trouble about? Please suggest if you have any thought.

Thank you so much in advance!

[tomsaudrins]

I assume you meant a dataverse table, not a column, that has 4000 records in it. Could the issue be due to delegation?

Just by connecting to the dataverse table you can retrieve up to 2000 rows at a time, so not all of the rows would be loaded. What could be an alternative would be a searchable dropdown, which then filters it's own items property on change (with delay for text input, not to filter on each keypress).

[KrishR]

Hi @tomsaudrins ,

I double checked and I don't think this would be a delegation issue. If it's a delegation issue it should show up to only limited values in drop down. But in my case I see missing values in between like 2,3 are missing between 1,2,3,4,5. If its delegation issue it should limit to 3 values like 1,2,3 and miss 4 and 5.

Thank you so much!

[tomsaudrins]

While in that case it most likely would not be delegation, what you could do instead is add a galery and use the same input source and check that the values do show up there.

If they don't, then the query could be wrong. Also it might be relevant to check in the network monitor mode what is the actual end query that is being sent to the server, as it could also be that records are not returned in the order of 1, 2, 3, 4, 5, but instead of 1, 4, 5, 2, 4, etc., depending on what that column actually represents.
Otherwise could you share the formulas, both from the "filtering" dropdown, and the one that is causing the issues.

[KrishR]

Hi @tomsaudrins ,

I tried to count the number of items that shows up in the drop down field and they match with the table in the backend. But not sure why they don't show up in drop down or search that value.

Let me know if this is helpful.

Thank you so much!