web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Sort Week Number dropd...

Power Apps

Unanswered

Sort Week Number dropdown in Descending order

(0) Share

Report

Report

Posted on by BharathDR

19

in this above Week Number dropdown, I have used Collection Formula

"ClearCollect(weekno,{Value:"Week Number"});
Collect(weekno,SortByColumns(Distinct('Weekly Report Dev','Week Number'),"Value",SortOrder.Descending));".

But still latest Week Numbers(14-2023,15-2023,etc) are not coming at first, can anyone help?

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

slima1 69 on at

Like
a
(0)

Report
Copy link

Link copied!
To sort the week number dropdown in descending order, you can modify your existing formula by adding the SortByColumns function to the ClearCollect statement:

ClearCollect( weekno, SortByColumns( Distinct('Weekly Report Dev', 'Week Number'), "Week Number", SortOrder.Descending ) );

In this formula, 'weekno' is the name of the collection you want to clear and collect data into. The Distinct function returns a table with a single column 'Week Number', containing unique values from the 'Weekly Report Dev' list. The SortByColumns function sorts this table in descending order based on the 'Week Number' column, and the resulting table is collected into the 'weekno' collection.
This should ensure that the week numbers are sorted in descending order in your dropdown.
BharathDR 19 on at

Like
a
(0)

Report
Copy link

Link copied!

Hii @slima1
The above code is not working,
I am sharing the values of 'Week Number' so that you can get an idea,
Please have a look and help me.

Join the conversation