⚡ Power Apps Formulas – Complete Reference

A comprehensive, example-driven reference for Power Fx functions in Microsoft Power Apps Canvas Apps. Every function has its own dedicated page with simple and complex real-world examples.

---

🗂️ Function Index

📨 Forms

Function	Description
SubmitForm	Submit a Form control to the data source (create or update)
NewForm	Set a form to New (create) mode
EditForm	Set a form to Edit mode
ViewForm	Set a form to View (read-only) mode
ResetForm	Reset form fields to original values, discarding unsaved edits

---

🧭 Navigation

Function	Description
Navigate	Change the displayed screen with optional transition and context vars
Back	Return to the previously displayed screen
Launch	Open a URL, email, phone link, or another Power App

---

💾 Data Write

Function	Description
Patch	Create or update records in a data source
Remove	Delete records from a data source or collection
Refresh	Reload data from the data source, clearing the local cache

---

🔍 Data Read

Function	Description
Filter	Return rows matching one or more conditions
LookUp	Find and return a single matching record
Search	Return rows where text columns contain a search string
Sort / SortByColumns	Sort a table by one or more columns
Distinct	Return a one-column table of unique values
First / Last	Return the first or last record from a table
Gallery.Selected	The currently selected record in a Gallery control

---

📦 Variables

Function	Description
Set	Create or update a global variable
UpdateContext	Create or update screen-local context variables

---

📦 Defaults and User

Function	Description
Defaults	Get default column values for a data source
User	Properties of the currently logged-in user

---

🗃️ Collections

Function	Description
Collect	Append records to an in-memory collection
ClearCollect	Clear and repopulate a collection

---

🔀 Logic

Function	Description
If	Conditional branching — single or multi-branch
Switch	Multi-value exact-match branching
IsBlank	Check if a value is blank, null, or empty string
IsEmpty	Check if a table or collection has zero rows
Coalesce	Return the first non-blank value from a list
With	Evaluate a formula in a named record scope

---

🔄 Data Transform

Function	Description
AddColumns	Add calculated columns to a table (non-destructive)
GroupBy	Group rows by one or more columns
ForAll	Iterate over rows and run a formula on each
ShowColumns / DropColumns	Select or remove specific columns from a table

---

📝 Text

Function	Description
Concatenate / &	Join text strings together
Text	Format a value as a string with a format pattern
Split	Split a string into a table of substrings
String Functions	Trim, Upper, Lower, Proper, Len, Left, Right, Mid, Find, Substitute
Value	Convert a text string to a number
IsMatch	Validate a string against a pattern or regex
EncodeUrl / JSON	Encode strings for URLs; convert records to JSON

---

📅 Date & Time

Function	Description
Date & Time Functions	Today, Now, DateAdd, DateDiff, DateValue, Year, Month, Day, Weekday

---

📊 Aggregation

Function	Description
CountRows / CountIf	Count rows in a table or matching a condition
Sum / Average / Min / Max	Aggregate numeric column values
Round / RoundUp / RoundDown	Round numbers to a specified decimal precision

---

🛠️ Debugging & Error Handling

Function	Description
Trace	Log messages to Power Apps Monitor for debugging
IsError / IfError	Detect and handle errors from functions like Patch

---

🧭 Quick Reference Cheat Sheet

NAVIGATION           FORMS               DATA WRITE         DATA READ
──────────────       ──────────────      ──────────────     ──────────────
Navigate()           SubmitForm()        Patch()            Filter()
Back()               NewForm()           Remove()           LookUp()
Launch()             EditForm()          Refresh()          Search()
                     ViewForm()                             Sort()
                     ResetForm()                            Distinct()
                                                           First() / Last()

VARIABLES            LOGIC               COLLECTIONS        TEXT
──────────────       ──────────────      ──────────────     ──────────────
Set()                If()                Collect()          Text()
UpdateContext()      Switch()            ClearCollect()     Concatenate() / &
Defaults()           IsBlank()                              Split()
User()               IsEmpty()                              Trim/Upper/Lower
                     Coalesce()                             IsMatch()
                     With()                                 Value()

AGGREGATION          DATA TRANSFORM      DEBUG / ERRORS     DATE & TIME
──────────────       ──────────────      ──────────────     ──────────────
Sum()                AddColumns()        Trace()            Today() / Now()
Average()            GroupBy()           IsError()          DateAdd()
Min() / Max()        ForAll()            IfError()          DateDiff()
CountRows()          ShowColumns()                          Text() (dates)
CountIf()            DropColumns()
Round()

---

📚 How to Use This Reference

Each function page includes:

• Overview — what the function does and when to use it
• Syntax — the exact formula signature with all parameters
• Parameters table — every argument explained
• Simple examples — 3 quick, easy-to-understand examples
• Complex examples — 3–6 real-world patterns used in production apps
• Best practices — proven tips to avoid common mistakes
• Related functions — direct links to connected functions
• Official Microsoft documentation link

---

🔗 Official Resources

• Power Fx Formula Reference (complete list)
• Delegation overview
• Power Apps Canvas App controls
• Power Apps community

---

Last updated: May 2026 | Microsoft Power Apps Canvas Apps | Power Fx