After Update How To Sort Distinct Values in a Drop Down Menu

[skburke]

Is it possible to sort a distinct data set within a drop down box?

I tried the followng without sucess:

Sort(Distinct(MajorsTable, Fund_Name_).Fund_Name_)

SortByColumns(Distinct(MajorsTable, Fund_Name_).Fund_Name_)

SortByColumns(Distinct(MajorsTable, Fund_Name_),Fund_Name_, Ascending)

I appreciatethe help in advance.

[hpkeong]

Hi

May you try on this:

- Distinct(Sort(DA, FieldtoSort, SortOrder), FieldToSort)

Example
Disticnt(Sort(Table1, Country), Ascending), Country)

Hope this helps,

TQ

[skburke · Accepted solution]

Your example did not work, but thanks to you, you got me pointed in the right direction. The below solution worked:

Distinct(Sort(MajorsTable, Fund_Name_),Fund_Name_)

[hpkeong]

Hi

Glad to hear that it works.

I am only trying to give the right syntax with numerous possible option.

Have a nice day.