A repair-request example
The fictional Finch Loom team stores request IDs, priorities and estimated hours. Two requests can have the same title, so a title alone doesn’t identify a saved record. These examples use US formula punctuation and original data names.
| Property or task | Formula | Result to inspect |
|---|---|---|
| Label text | "Request " & Text(Gallery1.Selected.ID) |
The selected request ID |
| Open requests | Filter(Requests, Status = "Open") |
A table of matching requests |
| One identified request | LookUp(Requests, ID = 42) |
One record, or blank |
| Missing owner | Coalesce(Gallery1.Selected.Owner, "Unassigned") |
A display fallback |
| Numeric input | Value(HoursInput.Text) * 2 |
A number, or a conversion error |
A display fallback doesn’t fill the source’s Owner column. Likewise, a number displayed as text doesn’t change the column’s type. Record the expected value before changing a formula; otherwise a plausible label can distract you from the wrong row.
Property and behavior formulas
A label’s Text property describes its current value. A button’s OnSelect describes an action. Keep data writes in the intended behavior and verify that a later input change updates the displayed calculation without repeating an earlier write.
In the local workspace, practice Set, collections and supported behavior functions only where the lesson exposes them. A collection is an in-memory table. Its contents don’t establish that every row from a remote source was loaded.
Function names stay English. Decimal-comma authoring uses different argument and chaining separators; the Microsoft localization reference explains those rules. A dot in Gallery1.Selected remains a property-access dot.
Checks and limits
Change the selected ID, enter a blank owner and try an invalid numeric input. Inspect a record that shares its title with another request. Each test probes a different assumption.
The course uses the official interpreter for its supported formulas and local models for canvas controls and data operations. It doesn’t implement the whole platform. Continue with gallery filters, forms and Patch or the Power Apps course.