Table.SingleRow
- 2 minutes to read
-
Contributors
About
Returns a single row from a table.
Syntax
Table.SingleRow(table as table) as record
Arguments
| Argument | Description |
|---|---|
| table | The Table to check. |
Remarks
- Table.SingleRow is similar to List.Single but requires a table as input.
Example
Table.SingleRow(Table.FromRecords(
{
[CustomerID = 1, Name = "Bob", Phone = "123-4567"]
}
))
equals [CustomerID = 1, Name = "Bob", Phone = "123-4567"]
| CustomerID | 1 |
| Name | Bob |
| Phone | 123-4567 |