A formula in Power Apps is a set of functions, written using Power Fx, the low-code language. Formula is used to define logic, behavior and activity of your app. This is similar to formula which is used in the excel.
Why is it Important?
Formulas help your app work properly. They tell it how to:
- Show data
- Filter data
- Move between screens
- Show messages and much more.
- How user will interact with the app.
Let’s have some examples.
| Use Case | Example Formula | Explanation |
| Display a user’s name | User().FullName | Shows the full name for logged In user. |
| Submit a form | SubmitForm(EditForm1) | Saves data which is present in EdotitForm1 to a connected data source |
| Filter a gallery by name | Filter(Employees, StartsWith(Name, txtSearch.Text)) | Filters employee list based on user input |
| Show a success message | Notify(“Saved successfully!”, NotificationType.Success) | Shows a pop-up message after an action |
| Navigate between screens | Navigate(Screen2, ScreenTransition.Fade) | Moves the user to another screen |
