First / Last — Power Fx function reference

Syntax

First( Table ) / Last( Table )

Examples

First(Sort(Orders, Created, SortOrder.Descending))

First(SortByColumns(Tasks, "DueDate", SortOrder.Ascending)).Title

Last(Filter(Orders, CustomerID = ThisItem.ID))

Common mistakes & gotchas

• Both return a single record (or blank on an empty table), not a one-row table — chain a field directly, e.g. First(Table).Column.
• Last() typically is not delegable on tabular connectors, since determining "last" requires knowing the full row order — watch for the delegation warning on large tables.

Related Power Fx functions

From Filtering, search & sort

Used in these tutorials