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