Power Query
Search…
published
Powered By GitBook
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.
1
Table.SingleRow(Table.FromRecords({[CustomerID = 1, Name = "Bob", Phone = "123-4567"]}))
Copied!
[CustomerID = 1, Name = "Bob", Phone = "123-4567"]
Last modified 3yr ago