cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
skburke
Frequent Visitor

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

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
skburke
Frequent Visitor

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_)

View solution in original post

3 REPLIES 3
hpkeong
Community Champion
Community Champion

Hi

 

May you try on this:

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

 

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

 

Hope this helps,

TQ

hpkeong
skburke
Frequent Visitor

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
Community Champion
Community Champion

Hi

 

Glad to hear that it works.

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

 

Have a nice day.

hpkeong

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (1,914)