The ForAll function allows you to run a formula for each record in a table or collection. It is commonly used for bulk processing, such as checking data, updating records, or performing actions on multiple items at once.
Basic Syntax
ForAll(Table, Formula)
Table → The table or collection to loop through
Formula → The action performed for each record
Example
ForAll(
TrainingInventory,
If(
RequestedSeats > AvailableSeats,
{
CourseName: CourseName,
SeatsToArrange: RequestedSeats - AvailableSeats
}
)
)
In this example:
TrainingInventory is the data source being processed. The formula checks each record one by one.
If the number of RequestedSeats is greater than AvailableSeats, it calculates how many additional seats need to be arranged.
It then returns a record showing:
- The course name
- The number of extra seats required
This means the app automatically identifies training sessions where capacity is insufficient.
When to Use ForAll
Use ForAll when you need to:
- Process multiple records at once
- Perform bulk calculations
- Create, update, or analyze multiple rows
- Apply logic to every item in a collection
Key Takeaway
ForAll is powerful for batch operations, but it should be used carefully with large datasets because it processes records one by one, which can impact performance.
