Skip to content

Latest commit

 

History

History
29 lines (19 loc) · 543 Bytes

table-singlerow.md

File metadata and controls

29 lines (19 loc) · 543 Bytes
description title
Learn more about: Table.SingleRow
Table.SingleRow

Table.SingleRow

Syntax

Table.SingleRow(table as table) as record  

About

Returns the single row in the one row table. If the table does not contain exactly one row, an error is raised.

Example 1

Return the single row in the table.

Usage

Table.SingleRow(Table.FromRecords({[CustomerID = 1, Name = "Bob", Phone = "123-4567"]}))

Output

[CustomerID = 1, Name = "Bob", Phone = "123-4567"]