Table of contents
TOC
Collapse the table of content
Expand the table of content

Record.FromTable

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

About

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

Record.FromTable(list as table) as record  

Arguments

ArgumentDescription
listThe 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]  
OrderID1
CustomerID1
ItemFishing rod
Price100
© 2018 Microsoft