Sort dropdown items

(0) Share

Report

Posted on by Daniël

147

Hi,

I have a dropdown with items that uses the following code:

Sort(
 Distinct(
 Filter(
 'Dataset',
 Year = YearSelector.Selected.Value
 ),
 'Week Number'
 ),
 SortOrder.Ascending
)

In short, I only want to see week numbers in the dropdown, that are available for the selected year. This part functions as expected - I am not getting week 52 to show up for year 2024, for example.

The issue I have is that the SortOrder doesn't seem to work and I am unsure what's causing that issue. Here you see the order seems rather random:

I reckon it might be referring to another value when activating the SortOrder. What can I do to fix this?

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

NPPlatform 606 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
You need to include the column you want to sort on. Something like:

Sort( Distinct( Filter( 'Dataset', Year = YearSelector.Selected.Value ), 'Week Number' ), 'Week Number', SortOrder.Ascending )

You can find more information in the documentation here: https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-sort. Let me know if this helps!
Daniël 147 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Thank you for the reply. So I thought it might have been something like that as well, but then the entire code fails. It also says 'Week Number' isn't recognized, which I find odd.

Could it have something to do with the fact that it's a Dataverse table, should I use different formatting? Most of my experience is with Sharepoint, so I might miss something small, yet essential. My column info:
Daniël 147 on at

Like
a
(0)

Report
Copy link

Link copied!

Does anyone have insights on this?
Verified answer

NPPlatform 606 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi, I made an error in my previous reply. The column you want to sort on should be Value, not 'Week Number'. Thus the following code should work correctly:

Sort( Distinct( Filter( 'Dataset', Year = YearSelector.Selected.Value ), 'Week Number' ), Value, SortOrder.Ascending )

When encountering errors in the future, try to build your formula step-by-step and see what suggestions Power Apps has for you. I found the solution by writing the Distinct()-formula, inserting a comma and seeing what the suggestions from Power Apps were. See the below screenshot, where Power Apps suggests 'ThisRecord' and 'Value'. By trying each suggestion you'll often find the solution.

If this answer solves your question, consider marking it as the solution for future users!
Daniël 147 on at

Like
a
(1)

Report
Copy link

Link copied!

Such a simple solution, but I definitely needed your help for it. Thank you, also for the other advice!
NPPlatform 606 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

No problem!