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 |