Cheat Sheet

Intermediate 🔹 Power Apps Canvas

Middle of designation

Text Functions

FORMULA 
Mid(Designation, 3, 5)
EXAMPLE EXPLANATION
Extracts 5 characters starting at position 3 of Designation.
Intermediate 🔹 Power Apps Canvas

Length of name

Text Functions

FORMULA 
Len(Name)
EXAMPLE EXPLANATION
Returns the number of characters in Name.
Intermediate 🔹 Power Apps Canvas

Long notes flag

Text Functions

FORMULA 
Len(Notes) > 50
EXAMPLE EXPLANATION
Checks whether Notes contains more than 50 characters.
Intermediate 🔹 Power Apps Canvas

Lowercase email

Text Functions

FORMULA 
Lower(Email)
EXAMPLE EXPLANATION
Returns Email entirely in lowercase.
Intermediate 🔹 Power Apps Canvas

Lowercase department compare

Text Functions

FORMULA 
Lower(Department) = "it"
EXAMPLE EXPLANATION
Compares Department to a lowercase value after converting it to lowercase.
Intermediate 🔹 Power Apps Canvas

Uppercase department

Text Functions

FORMULA 
Upper(Department)
EXAMPLE EXPLANATION
Returns Department entirely in uppercase for display.
Intermediate 🔹 Power Apps Canvas

Trim typed name

Text Functions

FORMULA 
Trim(NameInput.Text)
EXAMPLE EXPLANATION
Removes leading and trailing spaces from the text entered in the NameInput text input control
Intermediate 🔹 Power Apps Canvas

Trim only ends of email

Text Functions

FORMULA 
TrimEnds(EmailInput.Text)
EXAMPLE EXPLANATION
Removes leading and trailing spaces from the text entered in the EmailInput control — unlike Trim(), it leaves any spaces between words untouched.
Intermediate 🔹 Power Apps Canvas

Expand department abbreviation

Text Functions

FORMULA 
Substitute(Department, "IT", "Information Technology")
EXAMPLE EXPLANATION
Replaces the abbreviation IT with its full department name.
Intermediate 🔹 Power Apps Canvas

Redact email start

Text Functions

FORMULA 
Replace(Email, 1, 3, "***")
EXAMPLE EXPLANATION
Replaces the first three characters of Email with asterisks.
Intermediate 🔹 Power Apps Canvas

Email starts with admin

Text Functions

FORMULA 
StartsWith(Email, "admin")
EXAMPLE EXPLANATION
Checks whether Email begins with the text admin.
Intermediate 🔹 Power Apps Canvas

Company domain check

Text Functions

FORMULA 
EndsWith(Email, "@contoso.com")
EXAMPLE EXPLANATION
Checks whether Email ends with the company domain.
Intermediate 🔹 Power Apps Canvas

Find at symbol

Text Functions

FORMULA 
Find("@", Email)
EXAMPLE EXPLANATION
Returns the character position of the @ symbol within Email.
Intermediate 🔹 Power Apps Canvas

Convert typed salary to number

Text Functions

FORMULA 
Value(SalaryInput.Text)
EXAMPLE EXPLANATION
Converts the typed Salary text into a numeric value for calculations.
Intermediate 🔹 Power Apps Canvas

Format salary as currency

Text Functions

FORMULA 
Text(Salary, "$#,##0")
EXAMPLE EXPLANATION
Formats the numeric Salary as a currency-style text string.
Intermediate 🔹 Power Apps Canvas

Days since joining

Date & Time

FORMULA 
DateDiff(First(Employees).Salary, Today(), TimeUnit.Days)
EXAMPLE EXPLANATION
Calculates the number of days between JoiningDate and today.
Intermediate 🔹 Power Apps Canvas

Years of tenure

Date & Time

FORMULA 
DateDiff(JoiningDate, Today(), TimeUnit.Years)
EXAMPLE EXPLANATION
Calculates completed years of tenure from JoiningDate to today.
Intermediate 🔹 Power Apps Canvas

Months of tenure

Date & Time

FORMULA 
DateDiff(JoiningDate, Today(), TimeUnit.Months)
EXAMPLE EXPLANATION
Calculates completed months of tenure from JoiningDate to today.
Intermediate 🔹 Power Apps Canvas

Probation end date

Date & Time

FORMULA 
DateAdd(JoiningDate, 90, TimeUnit.Days)
EXAMPLE EXPLANATION
Calculates the date 90 days after JoiningDate, e.g. end of probation.
Intermediate 🔹 Power Apps Canvas

One year anniversary

Date & Time

FORMULA 
DateAdd(JoiningDate, 1, Years)
EXAMPLE EXPLANATION
Calculates the date exactly one year after JoiningDate.
Showing 61 – 80 of 132 formulae