Cheat Sheet

Basic 🔹 Power Apps Canvas

Current date and time

Date Basics

FORMULA 
Now()
EXAMPLE EXPLANATION
Returns the current date and time.
Basic 🔹 Power Apps Canvas

Joining year

Date Basics

FORMULA 
Year(JoiningDate)
EXAMPLE EXPLANATION
Extracts the calendar year from JoiningDate.
Basic 🔹 Power Apps Canvas

Joining month

Date Basics

FORMULA 
Month(JoiningDate)
EXAMPLE EXPLANATION
Extracts the month number (1-12) from JoiningDate.
Basic 🔹 Power Apps Canvas

Joining day

Date Basics

FORMULA 
Day(JoiningDate)
EXAMPLE EXPLANATION
Extracts the day of the month from JoiningDate.
Basic 🔹 Power Apps Canvas

Joined this year check

Date Basics

FORMULA 
Year(JoiningDate) = Year(Today())
EXAMPLE EXPLANATION
Checks whether the employee joined during the current calendar year.
Basic 🔹 Power Apps Canvas

Weekday of joining

Date Basics

FORMULA 
Weekday(JoiningDate)
EXAMPLE EXPLANATION
Returns the day of the week on which the employee joined.
Intermediate 🔹 Power Apps Canvas

Filter by department

Filter

FORMULA 
Filter(Employees, Department = "IT")
EXAMPLE EXPLANATION
Returns all employees in the IT department.
Intermediate 🔹 Power Apps Canvas

Filter by department and salary

Filter

FORMULA 
Filter(Employees, Department = "Finance", Salary > 50000)
EXAMPLE EXPLANATION
Returns only the rows from Employees where both conditions are true — Department is "Finance" and Salary is greater than 50000.
Intermediate 🔹 Power Apps Canvas

Filter with dropdown value

Filter

FORMULA 
Filter(Employees, Department = Dropdown1.Selected.Value)
EXAMPLE EXPLANATION
Returns employees matching the department chosen in a Dropdown control.
Intermediate 🔹 Power Apps Canvas

Filter salary range

Filter

FORMULA 
Filter(Employees, Salary >= 45000, Salary <= 90000)
EXAMPLE EXPLANATION
Returns employees whose Salary falls within a specified range.
Intermediate 🔹 Power Apps Canvas

Sort by name

Sort

FORMULA 
Sort(Employees, Name)
EXAMPLE EXPLANATION
Sorts employees alphabetically by Name, ascending by default.
Intermediate 🔹 Power Apps Canvas

Sort by joining date

Sort

FORMULA 
Sort(Employees, JoiningDate, SortOrder.Ascending)
EXAMPLE EXPLANATION
Sorts employees from earliest to most recent JoiningDate.
Intermediate 🔹 Power Apps Canvas

SortByColumns single column

Sort

FORMULA 
SortByColumns(Employees, "Name", SortOrder.Ascending)
EXAMPLE EXPLANATION
Sorts employees by Name using the column-name syntax.
Intermediate 🔹 Power Apps Canvas

Lookup single column result

LookUp

FORMULA 
LookUp(Employees, Email = "john.doe@contoso.com", Department)
EXAMPLE EXPLANATION
Returns only the Department value for the matching Email.
Intermediate 🔹 Power Apps Canvas

Lookup current user

LookUp

FORMULA 
LookUp(Employees, Email = User().Email)
EXAMPLE EXPLANATION
Returns the Employees record matching the currently signed-in user.
Intermediate 🔹 Power Apps Canvas

Lookup highest salary in department

LookUp

FORMULA 
LookUp(Employees, Department = "IT", Salary)
EXAMPLE EXPLANATION
Returns the Salary of the first matching IT employee found
Intermediate 🔹 Power Apps Canvas

First letter of name

Text Functions

FORMULA 
Left(Name, 1)
EXAMPLE EXPLANATION
Returns the first character of Name, useful for initials.
Intermediate 🔹 Power Apps Canvas

First 3 chars of department

Text Functions

FORMULA 
Left(Department, 3)
EXAMPLE EXPLANATION
Returns the first three characters of Department.
Intermediate 🔹 Power Apps Canvas

Last 4 chars of email

Text Functions

FORMULA 
Right(Email, 4)
EXAMPLE EXPLANATION
Returns the last four characters of Email.
Intermediate 🔹 Power Apps Canvas

Username from email

Text Functions

FORMULA 
Mid(Email, 1, Find("@", Email) - 1)
EXAMPLE EXPLANATION
Extracts the username portion of Email before the @ symbol.
Showing 41 – 60 of 132 formulae