Record.ToTable

Last updated 3 months ago

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]})