Record.FromTable

 

This topic applies to the Power Query Formula Language which can be used with Power Query and Power BI Desktop to build queries that mashup data. See the list of function categories.

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

Record.FromTable(list as table) as record  

ArgumentDescription
listThe Table to check.
  • An Expression.Error is thrown if the fields are not unique.
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
Show: