Record.FromTable

About

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

Syntax

Record.FromTable(list as table) as record  

Arguments

Argument Description
list The Table to check.

Remarks

  • An Expression.Error is thrown if the fields are not unique.

Example

let  

    input = Table.FromRows({{"OrderID",1} , {"CustomerID", 1}, {"Item", "Fishing rod"}, {"Price" , 100.00}}, {"Name", "Value"})  

in  

    Record.FromTable(input)  

equals [OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = 100.0]  
OrderID 1
CustomerID 1
Item Fishing rod
Price 100