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