You’re offline. This is a read only version of the page.
Is it possible to combine in one function DISTINCT and SORT? And how can it be possible to create a Collection using distinct?
Seems like they listened to you and actually changed the column's name to Value by now.
For others that may stumble on this again, the column is now called `Value`. Hence the updated code would be
`Sort(Distinct(Source, Column), Value)`
For others that may stumble on this again, the column is now called `Value`
In order to make this work, you have to replace the sort expression column name with the work "Value":
Sort(Distinct('List name','Column name'),Value,SortOrder.Ascending)
for a list named Schedule, where I am sorting by Task would like:
Sort(Distinct(Schedule,Task),Value,SortOrder.Ascending)
Good luck!
Does this solution really uses ";" or are they supposed to be commas?
Thanks for the link to the documentation. As of today, now that column is Value. I was reading other trends and Result doesn't work for me, but with your help I noticed it was changed.
6 years later and you still saved me!!!!
#1
WarrenBelz
637
Most Valuable Professional
#2
stampcoin
570
Super User 2025 Season 2
#3
Power Apps 1919
473
Share
Report
All responses (
Answers (
