Sorting Records

[Dicken]

I wanted a way to sort a records without converting to a table ; I came up with this , 
if anyone has better solution or improvement I would be interested. 

 let
     rec = [ B = "abc", E = 12, D = "def", C = 10 , A = 5] ,

    orderby = Record.FromList( 
                 List.Repeat( {null} , Record.FieldCount( rec)), 
                         List.Sort( Record.FieldNames( rec),Order.Ascending)
                             )
  in orderby & rec

Richard 

[jgeddes · Accepted solution]

You can try this...

let
    rec = [ B = "abc", E = 12, D = "def", C = 10 , A = 5],
    sortFields = List.Sort(Record.FieldNames(rec)),
    sortRecord = Record.ReorderFields(rec, sortFields, MissingField.Ignore) 
in
    sortRecord

[jgeddes · Accepted solution]

You can try this...

let
    rec = [ B = "abc", E = 12, D = "def", C = 10 , A = 5],
    sortFields = List.Sort(Record.FieldNames(rec)),
    sortRecord = Record.ReorderFields(rec, sortFields, MissingField.Ignore) 
in
    sortRecord

[Dicken · Accepted solution]

just to add, i did not know there was a re order , there are just so many m functions it's frightening.

[Dicken]

Thanks, had not thoiught of that.