Power Query conditional sorting

[Scott R]

I don't want the 'Sorted Rows' statement to error if those columns don't exist.
If none of those columns exist, then I wouldn't sort at all.
Here's what I have so far...

    CheckColumns_D = if Table.HasColumns(Source, {"DY"}) then 1 else 0,
    CheckColumns_P = if Table.HasColumns(Source, {"PER"}) then 2 else 0,
    CheckColumns_Y = if Table.HasColumns(Source, {"YR"}) then 3 else 0,
    #"Sorted Rows" = Table.Sort(Source,{{"YR", Order.Ascending}, {"PER", Order.Ascending}, {"DY", Order.Ascending}}),

 

[RoryA]

Do you still want to sort if one or two of them are missing? If so, you could do something like this:

    SortingList = List.Accumulate({"YR", "PER", "DY"}, {}, (s, c)=> if Table.HasColumns(Source, c) then s & {{c,  Order.Ascending}} else s),
    Result = if SortingList = {} then Source else Table.Sort(Source, SortingList)

 

[Scott R]

Works great. Thx!

 

[RoryA]

Glad we could help.