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

Record.FromTable

Owen Duncan|Last Updated: 4/19/2018

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