Solved: Re: Combo Box List

omi18 · ‎08-23-2021

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

StalinPonnusamy · ‎08-24-2021

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.

View solution in original post

Ramole · ‎08-23-2021

@omi18

How about if you try without the filter

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

Thank you
If this post helps, then Click on the Thumbs Up below. and Accept it as the solution . to help others find helpful.

omi18 · ‎08-23-2021

@Ramole ,

No Luck.

Thanks,

Omi

Ramole · ‎08-23-2021

@omi18

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

Thank you
If this post helps, then Click on the Thumbs Up below. and Accept it as the solution . to help others find helpful.

Ramole · ‎08-24-2021

@omi18

.

Thank you
If this post helps, then Click on the Thumbs Up below. and Accept it as the solution . to help others find helpful.

omi18 · ‎08-24-2021

Hi @Ramole ,

Thanks for your reply. But getting the same output.

-Omi

omi18 · ‎08-24-2021

@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 · ‎08-24-2021

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.