Record.ToTable

About

Returns a table of records containing field names and values from an input record.

Syntax

Record.ToTable(record as record) as table  

Arguments

Argument Description
record The Record to convert.

Remarks

  • The type of the return value of this function is {[Name = text, Value = any ]}.

Example

Record.ToTable([OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = 100.0] )  

equals  
OrderID 1
CustomerID 1
Item Fishing rod
Price 100