Table.Last

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

Table.Keys

Table.LastN

Last modified 4yr ago