These quick Power Fx tips come from real projects and save time every day.
- Use
With()to name intermediate values and avoid repeating long expressions - Use
Coalesce()to supply defaults for blank values - Run independent data loads in parallel with
Concurrent() - Use named formulas in
App.Formulasfor theme colours - Use
IfError()to catch failedPatchcalls - Use
Sequence()to generate rows for calendars and lists - Use
ForAll()withPatchfor bulk updates - Use
Trace()with Monitor to debug - Use
Selffor reusable control properties - Use
Parentinside containers and galleries