Table.SingleRow

Table.SingleRow
Returns the single row in the table.
function (table as table) as record
Description
Returns the single row in the one row table. If the table has more than one row, an exception is thrown.
Category
Table.Row operations
Examples
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"]

Table.SelectRowsWithErrors

Table.Skip

Last modified 4yr ago