Cheat Sheet

Basic 🔹 Power Apps Canvas

Store selected department

Variables (Set)

FORMULA 
Set(varSelectedDept, "IT")
EXAMPLE EXPLANATION
Stores a fixed department name in a global variable.
Basic 🔹 Power Apps Canvas

Store today flag

Variables (Set)

FORMULA 
Set(varToday, Today())
EXAMPLE EXPLANATION
Stores today's date in a global variable for reuse.
Basic 🔹 Power Apps Canvas

Store edit mode flag

Variables (Set)

FORMULA 
Set(varIsEditing, true)
EXAMPLE EXPLANATION
Stores a Boolean flag indicating the form is in edit mode.
Basic 🔹 Power Apps Canvas

Store salary threshold

Variables (Set)

FORMULA 
Set(varSalaryThreshold, 60000)
EXAMPLE EXPLANATION
Stores a numeric threshold value for later filtering.
Basic 🔹 Power Apps Canvas

Store selected email

Variables (Set)

FORMULA 
Set(varSelectedEmail, ThisItem.Email)
EXAMPLE EXPLANATION
Stores the Email of the selected record in a global variable.
Basic 🔹 Power Apps Canvas

Clear selected employee

Variables (Set)

FORMULA 
Set(varCurrentEmployee, Blank())
EXAMPLE EXPLANATION
Clears a previously stored employee record.
Basic 🔹 Power Apps Canvas

Store search text

Variables (Set)

FORMULA 
Set(varSearchText, TextInput1.Text)
EXAMPLE EXPLANATION
Stores the text input text in a global variable.
Basic 🔹 Power Apps Canvas

Store record count

Variables (Set)

FORMULA 
Set(varEmployeeCount, CountRows(Employees))
EXAMPLE EXPLANATION
Stores the current count of Employees records.
Basic 🔹 Power Apps Canvas

Toggle edit panel

Variables (UpdateContext)

FORMULA 
UpdateContext({showEditPanel: true})
EXAMPLE EXPLANATION
UpdateContext({showEditPanel: true}) sets a context variable called showEditPanel to true on the current screen only.
Basic 🔹 Power Apps Canvas

Hide edit panel

Variables (UpdateContext)

FORMULA 
UpdateContext({showEditPanel: false})
EXAMPLE EXPLANATION
UpdateContext({showEditPanel: false}) sets a context variable called showEditPanel to false on the current screen only
Basic 🔹 Power Apps Canvas

Store local search text

Variables (UpdateContext)

FORMULA 
UpdateContext({locSearch: TextInput1.Text})
EXAMPLE EXPLANATION
Stores the text input as a local, screen-scoped variable.
Basic 🔹 Power Apps Canvas

Toggle sort direction

Variables (UpdateContext)

FORMULA 
UpdateContext({locSortDesc: !locSortDesc})
EXAMPLE EXPLANATION
Flips a local Boolean that controls sort direction.
Basic 🔹 Power Apps Canvas

High earner flag

Conditional Logic (If)

FORMULA 
If(Salary > 80000, "High", "Standard")
EXAMPLE EXPLANATION
Checks if Salary is greater than 80000 — if true, it returns "High", otherwise it returns "Standard".
Basic 🔹 Power Apps Canvas

Missing manager check

Conditional Logic (If)

FORMULA 
If(IsBlank(Manager), "No Manager", Manager)
EXAMPLE EXPLANATION
Checks if Manager is empty — if it is, it shows "No Manager", otherwise it shows the actual Manager value.
Basic 🔹 Power Apps Canvas

Three-tier pay band

Conditional Logic (If)

FORMULA 
If(Salary > 100000, "Senior Band", Salary > 50000, "Mid Band", "Junior Band")
EXAMPLE EXPLANATION
Checks the conditions in order — if Salary is over 100000, it returns "Senior Band"; if not, it checks if Salary is over 50000 and returns "Mid Band"; if neither is true, it returns "Junior Band".
Basic 🔹 Power Apps Canvas

Recent joiner flag

Conditional Logic (If)

FORMULA 
If(DateDiff(JoiningDate, Today(), Days) <= 90, "New Joiner", "Established")
EXAMPLE EXPLANATION
Calculates the number of days between JoiningDate and today — if it's 90 days or less, it returns "New Joiner", otherwise it returns "Established".
Basic 🔹 Power Apps Canvas

Notes present check

Conditional Logic (If)

FORMULA 
If(Notes = "", "No notes", "Has notes")
EXAMPLE EXPLANATION
Checks if Notes is an empty string — if true, it returns "No notes", otherwise it returns "Has notes".
Basic 🔹 Power Apps Canvas

Filter result empty check

Blank & Empty Checks

FORMULA 
IsEmpty(Filter(Employees, Department = "HR"))
EXAMPLE EXPLANATION
Filters the Employees table for records where Department is "HR", and IsEmpty() checks if that filtered result has zero rows — returning true if no HR employees exist, false otherwise.
Basic 🔹 Power Apps Canvas

Search result empty check

Blank & Empty Checks

FORMULA 
IsEmpty(Search(Employees, "John", Name))
EXAMPLE EXPLANATION
Searches the Employees table's Name column for "John", and IsEmpty() checks if that search returned zero results — returning true if no match is found, false otherwise.
Basic 🔹 Power Apps Canvas

Current date

Date Basics

FORMULA 
Today()
EXAMPLE EXPLANATION
Returns today's date in the user's time zone.
Showing 21 – 40 of 132 formulae