Forum Discussion
Solved
Sorting Records
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 & recRichard
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 sortRecordjust to add, i did not know there was a re order , there are just so many m functions it's frightening.
3 Replies
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