Record.FieldValues
RecordReturns a list of field values from a record.
Syntax
Record.FieldValues(record as record) as listParameters
| Name | Type | Required | Description |
|---|---|---|---|
record | record | Yes | The record whose field values to return. |
Return Value
list — A list of values from the record, in field order.
Remarks
Record.FieldValues returns all values from a record as a list, preserving the order in which the fields appear. This is the value counterpart to Record.FieldNames. Together, these two functions let you decompose a record into parallel lists of names and values for dynamic processing or serialization.
Examples
Example 1: Get field values from the first Sales row
let
FirstRow = Sales{0},
Values = Record.FieldValues(FirstRow)
in
#table({"Value"}, List.Transform(Values, each {_}))Result
Value | |
|---|---|
| 1 | 1 |
| 2 | Alice |
| 3 | Widget A |
| 4 | Widgets |
| 5 | 25 |
| 6 | 4 |
| 7 | 2024-01-15 |
| 8 | East |
Compatibility
✓ Power BI Desktop✓ Power BI Service✓ Excel Desktop✓ Excel Online✓ Dataflows✓ Fabric Notebooks