Combo Box List

[omi18]

Hello,

I got into a weird issue. Where I have a combo box that shows the list of departments. In the combo box, I could see all the departments except one. 

This is the formula I have in the Items: Sort(Distinct('[Profile]',Department),Result,Ascending)

I did try with DropDown but the same problem. 

What I'm missing here? 

Any suggestions?

Thanks,

Omi

[Ramole]

@omi18 

How about if you try without the filter 

Distinct('[Profile]',Department).Result

[omi18]

@Ramole ,

No Luck.

Thanks,

Omi

[Ramole]

@omi18 

How about if you search Manually the missing one, also check the list for error typing the name 

[Ramole]

@omi18 

.

. 

[omi18]

Hi @Ramole ,

Thanks for your reply. But getting the same output. 

-Omi

[omi18]

@Ramole ,

Let's say I have 3000 + records and this missing department is a new entry to the list in this situation does the combo box has a limit on how many records it can consider for the dropdown? 

Thanks,

Omi

[StalinPonnusamy · Accepted solution]

Hi @omi18

As you know, Powerapps can get a maximum of 2000 records (Based on your app settings). So the only option is to use a Combo box with allow searching enabled. So query to get the desired items.

[Ramole]

@omi18