Answered

Sorting by Ascending or Descending in Dropdown

(0) Share

Report

Posted on by tlevine

230

Hi Community - I haven't been able to figure this one out but I am hoping it's pretty simple. The issue is that the list of items in my drop down are not sorted properly in accordance with the code listed below. To get the items for my drop down, I am finding the distinct values from my column called "Column Name" which is stored in a SharePoint List called "ListName". I am then looking to sort these in ascneding order.

Thanks in advance.

Sort(
 Distinct(
 'ListName',
 Trim('ColumnName')
 ),
 Ascending
)

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

eka24 20,923 on at

Like (0)

Report

Have you tried SortByColumns. Also what type of values do you have in the column, numbers or text?

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

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.

Was this reply helpful? Yes No
tlevine 230 on at

Like (0)

Report

@eka24 - the column is text, but I have not tried sortbycolumns, i will try this now and share the results

Was this reply helpful? Yes No
Verified answer

tlevine 230 on at

Like (3)

Report
@eka24 hi - I was able to achieve the results successfully using the following structure:

Distinct( Sort( 'ListName', Trim('ColumnName'), Ascending ), 'ColumnName' )

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

That's fine. Mark the solution to close it since it resolved

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

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.

Was this reply helpful? Yes No
GREGWOUARE 39 on at

Like (0)

Report

Hi there,

I don't know why, but in my case, I had to type
SortOrder.Ascending
to make it works

Anyway thanks you for your help

Was this reply helpful? Yes No