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
Solved! Go to 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.
How about if you try without the filter
Distinct('[Profile]',Department).Result
How about if you search Manually the missing one, also check the list for error typing the name
.
.
@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
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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
189 | |
54 | |
41 | |
37 | |
32 |
User | Count |
---|---|
252 | |
75 | |
71 | |
69 | |
68 |