Table

ForAll

Runs a formula for every record in a table and returns a table of the results.

Syntax

ForAll(Table, Formula)

Examples

  1. ForAll(colCart, Patch(OrderLines, Defaults(OrderLines), { Product: ThisRecord.Product, Qty: ThisRecord.Qty }))

    Saves each cart line

Maker notes

  • Use ThisRecord to refer to the current record.
  • Records are not guaranteed to run in order. Avoid changing the same table you are looping over.
Official documentation on Microsoft Learn

↑ ↓ moveEnter open