Summary

Completed

Formulas enhance functionality, performance, and user experience in your app. In this module, you learned about formulas:

  • How to modify control properties using formulas.

  • How to use formulas to do calculations.

  • And how to use conditional formatting in your app.

Some important items to remember are:

  • Conditional formatting can be used to change the color of text based on values, to show or hide fields, or even to disable fields based on a condition. It's a great way to enhance the usability of your app.

  • Use the calculation functions within your app to do aggregate functions and return values. This allows you to complete calculations in the app without needing other tools.

  • Each control type has a unique set of properties. Use these properties to modify the functionality and format of controls.

  • Use the validation functions (including IsBlank, IsBlankOrError, IsEmpty, IsNumeric, IsToday, and IsMatch) to prevent errors and prevent slowdowns in the processing of the data.

We hope you enjoyed this learning module! In the next module in this learning path, we'll learn how to create basic formulas to change behaviors in a Power Apps canvas app.

Before we depart this module, here are some valuable references for all developers.

Take a moment to view/bookmark these two important references for every developer. They are of indispensable for any Power Apps developer. Both are updated regularly.

Reference Description
Formula reference All of the available functions you can use when writing formulas.
Controls and properties in Power Apps This is a complete list of the controls available in Power Apps with a description of properties available for each control.

Localization references

If you need to build apps that support different languages and regions, see build global support into canvas apps.

For more information on formula separators, see formula separators and chaining operator.

Other references

For more information on Aggregate functions that summarize a set of numbers, see Power Apps Aggregate Functions.

For color use in Power Apps formulas, see Power Apps Color enumeration and functions.

For more information on data validation and examples of the various matching patterns, see IsMatch function in Power Apps.