Skip to content

Power Fx function

Logic, variables, and flow control

Switch

Picks a result by matching value.

What it does

Picks a result by matching value.

The job: Branching, looping, and state — the glue between reading data and changing it.

How to use Switch

Start from the task, not the alphabet. If you are shaping rows for a gallery, reach for Switch alongside the other data functions in its group; if you are saving, navigating, or changing state, use it on an event such as a button OnSelect rather than in a display property. When a formula misbehaves, check for a blank value where you expected text, then confirm the behaviour against the examples in the Power Fx function reference hub.

New to the language itself? Read What Is Microsoft Power Fx? first, then come back here when you need this specific tool.

Keep learning

Share this: