Table.SingleRow

Syntax

Table.SingleRow(table as table) as record

About

Returns the single row in the one row table. If the table has more than one row, an error is raised.

Example

Return the single row in the table.

Usage

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

Output

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