Table.First

Table.First
Returns the first row or a specified default value.
function (table as table, optional default as nullable any) as nullable any
Description
Returns the first row of the table or an optional default value, default, if the table is empty.
Category
Table.Row operations
Examples
Find the first row of the table.
Table.First(Table.FromRecords({[CustomerID = 1, Name = "Bob", Phone = "123-4567"], [CustomerID = 2, Name = "Jim", Phone = "987-6543"] ,  [CustomerID = 3, Name = "Paul", Phone = "543-7890"]}))
[CustomerID = 1, Name = "Bob", Phone = "123-4567"]
Find the first row of the table ({}) or return [a = 0, b = 0] if empty.
Table.First(Table.FromRecords({}), [a = 0, b = 0])
[a = 0, b = 0]

Table.FindText

Table.FirstN

Last modified 4yr ago