Record.ToList

Record.ToList is a Power Query M function that converts a record’s field values into a list. The function returns a list containing the values of all fields in the input record.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

Record.ToList( record as record ) as list

Description

Returns a list of values containing the field values from the input record.

Examples

Extract the field values from a record.

// Output: {1, 2, 3}
Record.ToList( [A = 1, B = 2, C = 3] )

Other functions related to Record.ToList are:

BI Gorilla Blog

Last update: August 25, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/record-tolist
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.