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"]
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for