Record.FromTable Function in Power Query

The Record.FromTable function in Power Query is used to convert a table with two columns (field names and values) into a record.

Syntax

Record.FromTable(table as table) as record

Example: Create a record from a table.

Power Query M

let
  // Creating a table with name-value pairs
  Source = Table.FromRecords(
    {
      [Name = "EmployeeID", Value = 1], 
      [Name = "Name", Value = "Ashish"], 
      [Name = "Company", Value = "TCS"]
    }
  ), 

  // Converting the table into a record
  return = Record.FromTable(Source)
in
  return   

The output of the above code will be:

[EmployeeID = 1, Name = "Ashish", Company = "TCS"]