Share via

Table.SingleRow

  • Article

Syntax

Table.SingleRow(table as table) as record

About

Returns the single row in the one row table. If the table does not contain exactly one row, an error is raised.

Example 1

Return the single row in the table.

Usage

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

Output

[CustomerID = 1, Name = "Bob", Phone = "123-4567"]