Cheat Sheet

Basic 🔹 Power Apps Canvas

Full contact line

Text Concatenation

FORMULA 
Name & " | " & Email & " | " & Location
EXAMPLE EXPLANATION
Builds a single-line contact summary from three fields.
Basic 🔹 Power Apps Canvas

Status text build

Text Concatenation

FORMULA 
"Status: " & If(IsActive, "Active", "Inactive")
EXAMPLE EXPLANATION
The & operator concatenates the static text "Status: " with the output of If(IsActive, "Active", "Inactive"), dynamically producing "Status: Active" or "Status: Inactive" based on the Boolean value of IsActive.
Basic 🔹 Power Apps Canvas

Joining year label

Text Concatenation

FORMULA 
"Joined in " & Year(JoiningDate)
EXAMPLE EXPLANATION
The & operator concatenates the static text "Joined in " with the numeric year extracted by Year(JoiningDate), producing a label like "Joined in 2026" — with Power Fx automatically converting the number to text during concatenation.
Basic 🔹 Power Apps Canvas

Salary plus bonus

Numeric Operations

FORMULA 
Salary + 5000
EXAMPLE EXPLANATION
The + operator performs simple numeric addition, adding a fixed bonus of 5000 to the Salary value to produce the updated total — useful for quick bonus or increment calculations in a Canvas App.
Basic 🔹 Power Apps Canvas

Salary minus deduction

Numeric Operations

FORMULA 
Salary - 2000
EXAMPLE EXPLANATION
The - operator performs numeric subtraction, deducting a fixed amount of 2000 from Salary to produce the net value after deduction — commonly used for calculating amounts after tax, fines, or other fixed deductions.
Basic 🔹 Power Apps Canvas

Monthly salary

Numeric Operations

FORMULA 
Salary / 12
EXAMPLE EXPLANATION
Divides annual Salary by 12 to get a monthly figure.
Basic 🔹 Power Apps Canvas

Salary doubled

Numeric Operations

FORMULA 
Salary * 2
EXAMPLE EXPLANATION
Multiplies Salary by 2.
Basic 🔹 Power Apps Canvas

Rounded monthly salary

Numeric Operations

FORMULA 
Round(Salary / 12, 0)
EXAMPLE EXPLANATION
Divides Salary by 12 and rounds to the nearest whole number.
Basic 🔹 Power Apps Canvas

Absolute salary gap

Numeric Operations

FORMULA 
Abs(Salary - 60000)
EXAMPLE EXPLANATION
The Abs() function returns the absolute value of Salary - 60000, stripping away the negative sign if present — so the result is always the positive difference between Salary and 60000, regardless of which value is larger.
Basic 🔹 Power Apps Canvas

Salary greater than

Comparisons

FORMULA 
Salary > 50000
EXAMPLE EXPLANATION
Checks whether Salary exceeds 50000.
Basic 🔹 Power Apps Canvas

Salary less than

Comparisons

FORMULA 
Salary < 40000
EXAMPLE EXPLANATION
Checks whether Salary is below 40000.
Basic 🔹 Power Apps Canvas

Salary equals

Comparisons

FORMULA 
Salary = 62000
EXAMPLE EXPLANATION
Checks whether Salary is exactly 62000.
Basic 🔹 Power Apps Canvas

Salary not equal

Comparisons

FORMULA 
Salary  62000
EXAMPLE EXPLANATION
Checks whether Salary is not equal to 62000.
Basic 🔹 Power Apps Canvas

Salary at least

Comparisons

FORMULA 
Salary >= 45000
EXAMPLE EXPLANATION
Checks whether Salary is 45000 or more.
Basic 🔹 Power Apps Canvas

Salary at most

Comparisons

FORMULA 
Salary <= 90000
EXAMPLE EXPLANATION
Checks whether Salary is 90000 or less.
Basic 🔹 Power Apps Canvas

Department equals text

Comparisons

FORMULA 
Department = "IT"
EXAMPLE EXPLANATION
Checks whether Department equals the text IT.
Basic 🔹 Power Apps Canvas

IsActive equals true

Comparisons

FORMULA 
IsActive = true
EXAMPLE EXPLANATION
Checks whether the employee is currently active.
Basic 🔹 Power Apps Canvas

JoiningDate before today

Comparisons

FORMULA 
JoiningDate < Today()
EXAMPLE EXPLANATION
Checks whether the employee joined before today's date.
Basic 🔹 Power Apps Canvas

Name not blank

Comparisons

FORMULA 
Name  ""
EXAMPLE EXPLANATION
Checks whether the Name field is a non-empty string.
Basic 🔹 Power Apps Canvas

Store current employee

Variables (Set)

FORMULA 
Set(varCurrentEmployee, ThisItem)
EXAMPLE EXPLANATION
Stores the selected gallery record in a global variable.
Showing 1 – 20 of 132 formulae