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!
SortByColumns(Distinct('Source Database','Column'),"Value")
the Word: "Value"
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!!!!
@mdevaney , I agree. Why do they use Result and not Value? I've often found myself using RenameColumns to make it consistent.
Nice, hadn't tried the Result. Thank You
WarrenBelz
146,731
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,075
Most Valuable Professional