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.