Cheat sheet · Power Apps

Cheat sheet for Power Apps formulas

Cheat sheet for Power Apps formulas (Power Fx): Patch, Filter, LookUp, collections, variables, named formulas, and user-defined functions with examples.

01Questions and answers

Frequently asked questions

What's the difference between Set and UpdateContext?

Set creates a global variable that applies on all screens. UpdateContext creates a context variable that only applies on the current screen.

What's the difference between Collect and ClearCollect?

Collect adds records to a collection. ClearCollect empties the collection first. From a connected data source, both load only up to the data row limit.

Why are there semicolons instead of commas in my formulas?

Because your locale uses a decimal comma, such as German. Then the semicolon separates arguments, the comma is the decimal separator, and ;; chains actions. Power Apps stores the formula independently of the locale.

How do I create a new record with Patch?

With Patch(Orders, Defaults(Orders), {Title: "New order"}). Defaults() creates a record with the default values of the data source.

Named formulas or OnStart?

Use named formulas for calculated values. Power Apps can defer the calculations until they're needed. Use OnStart for startup actions with side effects.

Why might Filter or LookUp miss matching records?

Filter returns a table, LookUp returns the first match. A nondelegable query may miss records beyond the data row limit.

02Next step

Your formulas are right, but the app is still slow?

Review your canvas app with the Performance Check for Microsoft Power Apps, from data queries and delegation to screens and formulas: 64 checkpoints, a scoring workbook, and a handbook.

Your process. My solution.

Tell me where things get stuck today - in a free, no-obligation initial consultation via Microsoft Teams, we will clarify what the Power Platform can do for your process and what a sensible first step looks like.