POWER FX

Power Fx Quick Reference

Searchable formula reference for Canvas Apps and Power Platform.

32 results

Data & Dataverse

(8)

Collections & Tables

(6)

Navigation & Screens

(4)

Text & Formatting

(5)

UI & User Experience

(6)

Delegation Guide

(3)

Power Fx Quick Reference

Data & Dataverse

Look up a single record

Filter records

Sort records

Search with StartsWith (delegable)

Create a record with Patch

Update a record with Patch

Delete a record

Submit a form control

Collections & Tables

Create / add to a collection

Load data source into a collection

Update a record in a collection

Remove from a collection

Add calculated columns

Group records

Navigation & Screens

Navigate to a screen

Go back to previous screen

Open an external URL

Read URL parameters (deep linking)

Text & Formatting

Concatenate strings

Format numbers and dates

Common text functions

If and Switch expressions

Check for blank / empty values

UI & User Experience

Show a notification banner

Show a loading spinner

Set and UpdateContext variables

Get the selected gallery item

Reset a form or input

Get current user info

Delegation Guide

Delegable functions (Dataverse)

Non-delegable functions (caution!)

Delegation workaround pattern