Power Query
published
Search
K
Comment on page

Table.SingleRow

Table.SingleRow

Returns the single row in the table.
function (table as table) as record

Description

Returns the single row in the one row table. If the table has more than one row, an exception is thrown.

Category

Table.Row operations

Examples

Return the single row in the table.
Table.SingleRow(Table.FromRecords({[CustomerID = 1, Name = "Bob", Phone = "123-4567"]}))
[CustomerID = 1, Name = "Bob", Phone = "123-4567"]