Cheat Sheet

Advanced 🔹 Power Apps Canvas

Named scope for repeated lookup

With & Sequence

FORMULA 
With({Mgr: LookUp(Employees, Name = "Michael Smith")}, Mgr.Email & " - " & Mgr.Department)
EXAMPLE EXPLANATION
First looks up the employee record where Name is "Michael Smith" and stores it in a temporary variable called Mgr, then combines that record's Email and Department fields into a single text string separated by " - " — using With() to avoid running the same LookUp() twice.
Advanced 🔹 Power Apps Canvas

Safe Patch with error notification

Error Handling & Branching

FORMULA 
IfError(Patch(Employees, LookUp(Employees, Email = "xyzz@contoso.com"), {Salary: Value(SalaryInput.Text)}), Notify("Update failed", NotificationType.Error))
EXAMPLE EXPLANATION
Attempts a Patch and shows an error notification if the operation fails, e.g. due to invalid input.
Advanced 🔹 Power Apps Canvas

Department color switch

Error Handling & Branching

FORMULA 
Switch(Department, "IT", "Blue", "HR", "Green", "Finance", "Orange", "Sales", "Purple", "Gray")
EXAMPLE EXPLANATION
Returns a color-name string based on Department, with a Gray default for unmatched values.
Advanced 🔹 Power Apps Canvas

Coalesce manager fallback

Error Handling & Branching

FORMULA 
Coalesce(Manager.Text, "Unassigned")
EXAMPLE EXPLANATION
Returns Manager, or the text Unassigned if Manager is blank.
Advanced 🔹 Power Apps Canvas

Domain match check

Error Handling & Branching

FORMULA 
IsMatch(First(Employees).Email, "^[^@]+@contoso\.com$")
EXAMPLE EXPLANATION
Uses a custom regular expression to verify Email belongs to the contoso.com domain.
Advanced 🔹 Power Apps Canvas

Third employee alphabetically

Record Selection

FORMULA 
Index(SortByColumns(Employees, "Name", SortOrder.Ascending), 3)
EXAMPLE EXPLANATION
Returns the 3rd employee record when sorted alphabetically by Name.
Advanced 🔹 Power Apps Canvas

Most recently joined employee

Record Selection

FORMULA 
Last(SortByColumns(Employees, "JoiningDate", SortOrder.Ascending))
EXAMPLE EXPLANATION
Returns the record of the most recently joined employee.
Advanced 🔹 Power Apps Canvas

Top 3 earners

Record Selection

FORMULA 
FirstN(SortByColumns(Employees, "Salary", SortOrder.Descending), 3)
EXAMPLE EXPLANATION
Returns the 3 highest-paid employee records.
Advanced 🔹 Power Apps Canvas

First active employee found

Record Selection

FORMULA 
First(Filter(Employees, IsActive = true))
EXAMPLE EXPLANATION
Returns the first active employee record encountered.
Advanced 🔹 Power Apps Canvas

UpdateIf resetting notes for a department

Advanced SharePoint CRUD

FORMULA 
UpdateIf(Employees, Department = "Marketing", {Notes: ""})
EXAMPLE EXPLANATION
Clears the Notes field for every employee in the Marketing department.
Advanced 🔹 Power Apps Canvas

Patch using a record variable built with Set

Advanced SharePoint CRUD

FORMULA 
Set(varNewEmployee, {Name: "New Hire", Department: "IT", Salary: 52000, IsActive: true}); Patch(Employees, Defaults(Employees), varNewEmployee)
EXAMPLE EXPLANATION
Builds the new record in a variable first, then patches it into the data source, useful for reuse across multiple buttons.
Advanced 🔹 Power Apps Canvas

Split name into table

Advanced Text Processing

FORMULA 
First(Split(Trim(Email.Text), " ")).Value
EXAMPLE EXPLANATION
Trims extra spaces from Email, then splits it into a table of individual name-part strings.
Showing 121 – 132 of 132 formulae