Power Fx · Function Reference

Power Apps Formulas — Complete Reference

A comprehensive, example-driven reference for 48 Power Fx functions — simple examples, real-world patterns, best practices, and common mistakes for every function.

← Back to Portfolio Hub

📨 Forms

Submit a Form control to the data source

Set a form to New (create) mode

Set a form to Edit mode

Set a form to View (read-only) mode

Reset form fields, discarding unsaved edits

🧭 Navigation

Change the displayed screen

Return to the previously displayed screen

Open a URL, email, phone link, or another app

💾 Data Write

Create or update records in a data source

Delete records from a data source or collection

Reload data from the data source

🔍 Data Read

Return rows matching one or more conditions

Find and return a single matching record

Return rows where text columns contain a string

Sort / SortByColumns

Sort a table by one or more columns

Return a one-column table of unique values

Return the first or last record from a table

Gallery.Selected

The currently selected record in a Gallery

📦 Variables

Create or update a global variable

Create or update screen-local context variables

👤 Defaults and User

Get default column values for a data source

Properties of the currently logged-in user

🗃️ Collections

Append records to an in-memory collection

Clear and repopulate a collection

🔀 Logic

Conditional branching — single or multi-branch

Multi-value exact-match branching

Check if a value is blank, null, or empty

Check if a table or collection has zero rows

Return the first non-blank value from a list

Evaluate a formula in a named record scope

🔄 Data Transform

Add calculated columns to a table

Group rows by one or more columns

Iterate over rows and run a formula on each

ShowColumns / DropColumns

Select or remove specific columns

📝 Text

Concatenate / &

Join text strings together

Format a value as a string

Split a string into a table of substrings

String Functions

Trim, Upper, Lower, Proper, Len, Left, Right, Mid, Find, Substitute

Convert a text string to a number

Validate a string against a pattern or regex

EncodeUrl / JSON

Encode strings for URLs; convert records to JSON

📅 Date & Time

Date & Time Functions

Today, Now, DateAdd, DateDiff, DateValue, Year, Month, Day, Weekday

📊 Aggregation

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 precision

🛠️ Debugging & Error Handling

Log messages to Power Apps Monitor

IsError / IfError

Detect and handle errors from functions like Patch