← Back to Table functions

Table.SingleRow

This function retrieves the only row in a table with one row. If the table does not have exactly one row, an error will be triggered.

Syntax

Table.SingleRow(table as table) as record

About

This function retrieves the only row in a table with one row. If the table does not have exactly one row, an error will be triggered.

Explanation

Retrieve the individual record from the table by using Power Query function MTable.SingleRow(Table.FromRecords({[CustomerID = 1, Name = "Bob", Phone = "123-4567"]})). The output will be [CustomerID = 1, Name = "Bob", Phone = "123-4567"].