Record.ToList
A record's values as a list, without the field names.
Group: Record. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Record.ToList(record as record) as list| Parameter | Type | Description |
|---|---|---|
record | record | The record to turn into a list. |
Returns
list. The values in the record's order.
Remarks
- The same as
Record.FieldValues. To keep the names as well, useRecord.ToTable.
Examples
An order as a list
Record.ToList([Order = 1001, Shop = "Oslo", Total = 120]){1001, "Oslo", 120}Summing the amounts of a record
List.Sum(Record.ToList([Jan = 120, Feb = 90, Mar = 150]))360