OpenBI Docs Buy

Record.FieldValues

The values of a record's fields as a list, in the record's order.

Group: Record. Power Query M has it too: a query that uses it is written as in Power BI.

Syntax

Record.FieldValues(record as record) as list
ParameterTypeDescription
recordrecordThe record whose values you want.

Returns

list. One item per field.

Remarks

Examples

An order's values

Record.FieldValues([Order = 1001, Shop = "Oslo", Total = 120])
{1001, "Oslo", 120}

Record.FieldNames, Record.ToList, Record.ToTable.

Last updated · OpenBI Studio 0.3.79