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

Table.SingleRow

Owen Duncan|Last Updated: 4/19/2018

About

Returns a single row from a table.

Table.SingleRow(table as table) as record  

Arguments

ArgumentDescription
tableThe 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"]  
CustomerID1
NameBob
Phone123-4567
© 2018 Microsoft