← Back to Record functions

Record.ToTable

Generates a table that includes the columns Name and Value, with each field from the record represented as a row in the table.

Syntax

Record.ToTable(record as record) as table

About

Generates a table that includes the columns Name and Value, with each field from the record represented as a row in the table.

Explanation

Retrieve the table data from the specified record using Power Query function MRecord.ToTable(). The table should include the fields OrderID, CustomerID, Item, and Price with their respective values. The output table can be generated using the OutputTable.FromRecords() function by providing the field names and their corresponding values in a structured format.