cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Drop down shows only first 3 values

Hello Experts ,

 

I am facing one weird issue in power app , i have one dropdown where i am displaying data using distinct but that drop down shows only first 3 values , even if there are many values in DB.

 

Do we have some property which restrict this ??

here what i am writing on item property of dropdown. Please advise

 

Distinct('[dbo].[ActivityRecProj]',COMPANY)

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Hello @eka24 , Finally i am able to solve this issue , this was because of  delegation  as you mentioned in your first response. but  here the catch is , even if you use distinct in your formula ,delegation  will apply on the basis of no of record on the view or table. for example

in my Company View i had 968 record and my delegation was 500 so it was showing value only till 500 even if i am using distinct formula. after using distinct it was showing only 4 unique value at backend DB but power app delegation  doesn't consider this . Also you cannot apply delegation  value more than 2000 its between 1 to 2000 

View solution in original post

7 REPLIES 7
eka24
Super User
Super User

Your code seem ok.

Do you have more than 3 different kinds of data in the Company column?

Can you show a sample

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

 

Anonymous
Not applicable

Hello @eka24 , Yes these are unique fields.  Please find the screen shot below.

1. Power App

Capture41.PNG

2.View in Database 

Capture42.PNG

That is interesting.

Is your delegation limit set above 3, just being curious (FILE...SETTINGS...ADVANCED SETTINGS?

Also place same formula on a different control such as a new dropdown.

Or Restart the APP

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Anonymous
Not applicable

yeh @eka24  This is weird , please find the screen shot below.

 

my delegation settings.

Capture43.PNG

After addning new drop down still same. also tried with combobox too but same 

Capture44.PNG

 

tried on different browser , logout login but still same 

What happen when you remove the Distinct from the Formula. Do you get all?

Also take a screen shot of the Formula with the Distinct

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Anonymous
Not applicable

@eka24 It shows values repeatedly but still 3 values till Sys not the fourth one .

Capture45.PNG

Formula without Distinct 

Capture46.PNG

 

Anonymous
Not applicable

Hello @eka24 , Finally i am able to solve this issue , this was because of  delegation  as you mentioned in your first response. but  here the catch is , even if you use distinct in your formula ,delegation  will apply on the basis of no of record on the view or table. for example

in my Company View i had 968 record and my delegation was 500 so it was showing value only till 500 even if i am using distinct formula. after using distinct it was showing only 4 unique value at backend DB but power app delegation  doesn't consider this . Also you cannot apply delegation  value more than 2000 its between 1 to 2000 

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,869)