Power Query
published
Search
K

Record.ToTable

Record.ToTable

Returns a table with each row being a field name and value of the input record.
function (record as record) as table

Description

Returns a table containing the columns Name and Value with a row for each field in record.

Category

Record.Serialization

Examples

Return the table from the record.
Record.ToTable([OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = 100.0])
Table.FromRecords({[Name="OrderID", Value=1],[Name="CustomerID", Value=1],[Name="Item", Value="Fishing rod"],[Name="Price", Value=100]})