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 exception is thrown.

Example 1

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