Power Fx function

ThisRecord — Power Fx function reference

Current row in ForAll / Filter.

Syntax

powerfx

ThisRecord.ColumnName

powerfx

Filter(Orders, ThisRecord.Amount > 0)

→ Field value

powerfx

Filter(Orders, ThisRecord.Amount > 0 && ThisRecord.Status = "Open")

powerfx

ForAll(colCart, Patch(Products, LookUp(Products, SKU = ThisRecord.SKU), {Stock: Stock - ThisRecord.Qty}))

ThisRecord is the generic per-row reference inside table functions (ForAll, Filter, Sort, With over a table) — a bare column name often works too for single-table formulas, but ThisRecord becomes necessary to disambiguate nested table operations.
In a nested ForAll/Filter, ThisRecord refers to the innermost table unless the outer one is aliased with As.

From Records & scope references