Most Commonly Used Formulas In PowerApps

Commonly Used Formulas in PowerApps

Many PowerApps formulas are available, and it would be impractical to list them here. However, I can provide a list of some of the most commonly used formulas in PowerApps, along with a brief description of their purpose.

General Formulas in PowerApps

Text- Converts a value to text format
Value- Converts a text value to a number
Now- Returns the current date and time
Today- Returns the current date
Concatenate- Joins two or more text values together
If- Evaluates a condition and returns one value if true, another value if false

Data Formulas in PowerApps

Filter- Returns a subset of records from a data source that meets specified criteria
SortByColumns- Sorts a table or collection by one or more columns
Search- Searches a data source for a specific term or phrase
LookUp- Searches a table or collection for a specific record and returns a single value from that record
Patch- Updates or creates a record in a data source
Collect- Creates a new collection and adds records to it
ClearCollect- Clears an existing collection and replaces it with a new set of records

Formulas for Controls in PowerApps

Navigate- Navigates to a different screen in the app
Reset- Clears the values in a control
UpdateContext- Sets the value of a context variable
Set- Sets the value of a control or property
ShowError- Displays an error message to the user
IsBlank- Checks if a value is blank or null
IsEmpty- Checks if a collection or table is empty

These are just a few examples of the many formulas available in PowerApps. You can find more information on specific formulas and their usage in the PowerApps documentation.