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