Table.SingleRow

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

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

Output

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