Power Fx Cheat Sheet

58 functions

• If

  Logic
  If(condition, then, [else])

  Returns one value when a condition is true and another when it is not.

  If(Score >= 50, "Pass", "Fail")

  Copy example

• Switch

  Logic
  Switch(value, match, result, [default])

  Compares a value with several cases and returns the first match.

  Switch(Status, "New", Blue, "Done", Green, Gray)

  Copy example

• And

  Logic
  And(condition1, condition2, [...])

  True only when every condition is true. Works like the && operator.

  And(Age >= 18, HasId)

  Copy example

• Or

  Logic
  Or(condition1, condition2, [...])

  True when at least one condition is true. Works like the double pipe operator.

  Or(Role = "Admin", Role = "Owner")

  Copy example

• Not

  Logic
  Not(value)

  Reverses true and false.

  Not(IsBlank(txtName.Text))

  Copy example

• IsBlank

  Logic
  IsBlank(value)

  True when a value is blank or empty text.

  IsBlank(txtName.Text)

  Copy example

• IsEmpty

  Logic
  IsEmpty(table)

  True when a table or collection has no rows.

  IsEmpty(colCart)

  Copy example

• Coalesce

  Logic
  Coalesce(value1, value2, [...])

  Returns the first value that is not blank.

  Coalesce(txtNick.Text, "Guest")

  Copy example

• IfError

  Logic
  IfError(value, fallback)

  Returns a fallback when the first formula produces an error.

  IfError(Value(txtQty.Text), 0)

  Copy example

• With

  Logic
  With(record, formula)

  Names values once so a formula can reuse them.

  With({tax: 0.2}, Price * (1 + tax))

  Copy example

• Text

  Text
  Text(value, [format])

  Converts a number or date to text with an optional format.

  Text(Today(), "dd mmm yyyy")

  Copy example

• Concat

  Text
  Concat(table, formula, [separator])

  Joins the values from each row of a table into one text.

  Concat(colTags, Value, ", ")

  Copy example

• Left

  Text
  Left(text, count)

  Takes characters from the start of a text.

  Left("PowerApps", 5)

  Copy example

• Mid

  Text
  Mid(text, start, [count])

  Takes characters from the middle of a text.

  Mid("PowerApps", 6, 4)

  Copy example

• Len

  Text
  Len(text)

  Counts the characters in a text.

  Len(txtName.Text)

  Copy example

• Upper

  Text
  Upper(text)

  Converts text to upper case.

  Upper(txtCode.Text)

  Copy example

• Substitute

  Text
  Substitute(text, old, new, [instance])

  Replaces matching text inside another text.

  Substitute(txtPhone.Text, " ", "")

  Copy example

• Split

  Text
  Split(text, separator)

  Splits text into a one-column table.

  Split("a,b,c", ",")

  Copy example

• Find

  Text
  Find(find, within, [start])

  Returns the position of some text, or blank if it is not found.

  Find("@", txtEmail.Text)

  Copy example

• StartsWith

  Text
  StartsWith(text, start)

  True when a text begins with the given value.

  StartsWith(Title, txtSearch.Text)

  Copy example

• IsMatch

  Text
  IsMatch(text, pattern, [options])

  Checks a text against a pattern or regular expression.

  IsMatch(txtEmail.Text, Match.Email)

  Copy example

• Value

  Text
  Value(text, [language])

  Converts text to a number.

  Value("42.5")

  Copy example

• Today

  Date & Time
  Today()

  Current date without a time.

  Today()

  Copy example

• Now

  Date & Time
  Now()

  Current date and time.

  Now()

  Copy example

• Date

  Date & Time
  Date(year, month, day)

  Builds a date from its parts.

  Date(2026, 12, 31)

  Copy example

• DateAdd

  Date & Time
  DateAdd(date, number, [unit])

  Adds days, months or other units to a date.

  DateAdd(Today(), 7, TimeUnit.Days)

  Copy example

• DateDiff

  Date & Time
  DateDiff(start, end, [unit])

  Counts the units between two dates.

  DateDiff(StartDate, EndDate, TimeUnit.Days)

  Copy example

• EOMonth

  Date & Time
  EOMonth(date, months)

  Returns the last day of a month.

  EOMonth(Today(), 0)

  Copy example

• Sum

  Math
  Sum(table, formula)

  Adds up a column or a list of numbers.

  Sum(colOrders, Amount)

  Copy example

• Average

  Math
  Average(table, formula)

  Averages a column or a list of numbers.

  Average(colOrders, Amount)

  Copy example

• Max

  Math
  Max(table, formula)

  Finds the largest value.

  Max(colOrders, Amount)

  Copy example

• Round

  Math
  Round(number, digits)

  Rounds a number to the given number of decimals.

  Round(3.14159, 2)

  Copy example

• Filter

  Tables
  Filter(table, condition, [...])

  Returns the rows that match every condition.

  Filter(Tasks, Status = "Open")

  Copy example

• LookUp

  Tables
  LookUp(table, condition, [result])

  Finds the first row that matches a condition.

  LookUp(Users, ID = 5, Email)

  Copy example

• Sort

  Tables
  Sort(table, formula, [order])

  Sorts a table by a formula.

  Sort(Tasks, DueDate, SortOrder.Ascending)

  Copy example

• SortByColumns

  Tables
  SortByColumns(table, column, [order, ...])

  Sorts a table by one or more column names.

  SortByColumns(Tasks, "Priority", SortOrder.Descending)

  Copy example

• FirstN

  Tables
  FirstN(table, [count])

  Returns the first rows of a table.

  FirstN(Tasks, 10)

  Copy example

• CountRows

  Tables
  CountRows(table)

  Counts the rows in a table.

  CountRows(Filter(Tasks, Done))

  Copy example

• Distinct

  Tables
  Distinct(table, formula)

  Returns the unique values of a column.

  Distinct(Tasks, Category)

  Copy example

• AddColumns

  Tables
  AddColumns(table, name, formula, [...])

  Adds calculated columns to a table.

  AddColumns(Users, "Full", First & " " & Last)

  Copy example

• GroupBy

  Tables
  GroupBy(table, column, [...], groupName)

  Groups rows by one or more columns.

  GroupBy(Tasks, "Owner", "Rows")

  Copy example

• ForAll

  Tables
  ForAll(table, formula)

  Runs a formula for every row of a table.

  ForAll(colCart, Patch(Orders, Defaults(Orders), {Item: Item}))

  Copy example

• Patch

  Data
  Patch(source, record, changes, [...])

  Creates or updates a record in a data source.

  Patch(Tasks, Defaults(Tasks), {Title: "New"})

  Copy example

• Collect

  Data
  Collect(collection, item, [...])

  Adds records to a collection.

  Collect(colCart, {Item: "Pen", Qty: 2})

  Copy example

• ClearCollect

  Data
  ClearCollect(collection, item, [...])

  Empties a collection, then fills it with new data.

  ClearCollect(colOpen, Filter(Tasks, Status = "Open"))

  Copy example

• Clear

  Data
  Clear(collection)

  Removes all records from a collection.

  Clear(colCart)

  Copy example

• RemoveIf

  Data
  RemoveIf(source, condition, [...])

  Deletes the records that match a condition.

  RemoveIf(colCart, Qty <= 0)

  Copy example

• SaveData

  Data
  SaveData(collection, name)

  Saves a collection to the device storage.

  SaveData(colCart, "cart")

  Copy example

• Set

  App
  Set(name, value)

  Sets a global variable.

  Set(gblUser, User().Email)

  Copy example

• UpdateContext

  App
  UpdateContext({ name: value })

  Sets screen-level context variables.

  UpdateContext({locOpen: true})

  Copy example

• Navigate

  App
  Navigate(screen, [transition], [context])

  Moves to another screen.

  Navigate(scrHome, ScreenTransition.Fade)

  Copy example

• Notify

  App
  Notify(message, [type], [timeout])

  Shows a banner message to the user.

  Notify("Saved", NotificationType.Success)

  Copy example

• SubmitForm

  App
  SubmitForm(form)

  Saves the data in an edit form.

  SubmitForm(frmTask)

  Copy example

• Concurrent

  App
  Concurrent(formula1, formula2, [...])

  Runs several formulas at the same time.

  Concurrent(ClearCollect(colA, A), ClearCollect(colB, B))

  Copy example

• SetFocus

  App
  SetFocus(control)

  Moves keyboard focus to a control.

  SetFocus(txtName)

  Copy example

• RGBA

  App
  RGBA(red, green, blue, alpha)

  Builds a color from its parts.

  RGBA(116, 39, 116, 1)

  Copy example

• JSON

  App
  JSON(data, [format])

  Turns a table or record into JSON text.

  JSON(colCart, JSONFormat.IndentFour)

  Copy example

• ParseJSON

  App
  ParseJSON(jsonText)

  Reads JSON text into an untyped object.

  ParseJSON(txtJson.Text)

  Copy example