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

Table.SingleRow

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

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