Drop down shows only first 3 values

[SachinG31]

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)

[eka24]

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.

[SachinG31]

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

1. Power App

2.View in Database 

[eka24]

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.

[SachinG31]

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

my delegation settings.

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

tried on different browser , logout login but still same 

[eka24]

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.

[SachinG31]

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

Formula without Distinct 

[SachinG31 · Accepted solution]

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