Skip to content
← Back to the guide

Power Fx primer

7slides. Screenshot a slide, download it as a PNG, or use your browser's Print → Save as PDF for a LinkedIn-ready multi-page carousel — each slide becomes one page.

M
solvingmicrosoft365.com
1 / 7

Power Fx primer

A practical introduction to Power Fx, the formula language used across Power Apps and the Power Platform.

Solving Microsoft 365 · www.solvingmicrosoft365.com/guides/power-fx-primer

Slide 1Download PNG
M
solvingmicrosoft365.com
2 / 7
01

The mental model

A Power Fx formula is an expression — it evaluates to a value. You bind expressions to control properties: a button's OnSelect, a label's Text, a gallery's Items, a field's default value.

Solving Microsoft 365 · www.solvingmicrosoft365.com/guides/power-fx-primer

Slide 2Download PNG
M
solvingmicrosoft365.com
3 / 7
02

Core functions

A handful of functions cover most scenarios:

Solving Microsoft 365 · www.solvingmicrosoft365.com/guides/power-fx-primer

Slide 3Download PNG
M
solvingmicrosoft365.com
4 / 7
03

Working with data

Connect a canvas app to a data source (SharePoint, Dataverse, SQL), and the source appears as a table you query with Power Fx:

Solving Microsoft 365 · www.solvingmicrosoft365.com/guides/power-fx-primer

Slide 4Download PNG
M
solvingmicrosoft365.com
5 / 7
04

Variables and scope

Three variable scopes:

Solving Microsoft 365 · www.solvingmicrosoft365.com/guides/power-fx-primer

Slide 5Download PNG
M
solvingmicrosoft365.com
6 / 7
05

Delegation

A critical concept: delegation is when Power Fx pushes a filter/sort back to the data source's server (SharePoint, SQL, Dataverse) rather than fetching everything and filtering client-side. Without delegation, your app…

Solving Microsoft 365 · www.solvingmicrosoft365.com/guides/power-fx-primer

Slide 6Download PNG
M
solvingmicrosoft365.com
7 / 7
06

Learning approach

The fastest way to learn Power Fx: build a simple app from a SharePoint list, then progressively add filter, sort, search, edit, delete. Each step uses a few more Power Fx functions and patterns. In a week of regular pr…

Solving Microsoft 365 · www.solvingmicrosoft365.com/guides/power-fx-primer

Slide 7Download PNG

Auto-generated from Power Fx primer. This page is not indexed and isn't part of the guide itself.