Table.SingleRow
- 2 minutes to read
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 |