Table.SingleRow

About

Returns a single row from a table.

Syntax

Table.SingleRow(table as table) as record  

Arguments

Argument Description
table The Table to check.

Remarks

  • Table.SingleRow is similar to List.Single but requires a table as input.

Example

Table.SingleRow(Table.FromRecords(  
  
{  
  
      [CustomerID = 1, Name = "Bob", Phone = "123-4567"]  
  
}  
  
))  
  
equals [CustomerID = 1, Name = "Bob", Phone = "123-4567"]  
CustomerID 1
Name Bob
Phone 123-4567