Comment on page
Table.First
Returns the first row or a specified default value.
function (table
as table, optionaldefault
as nullable any) as nullable any
Returns the first row of the
table
or an optional default value, default
, if the table is empty.Table.Row operations
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]
Last modified 5yr ago