In previous chapters, we looked at how to build the skeletons of the apps by using screens with controls to build up the user interface. In this chapter, we will now begin to look at how we can use functions with PowerApps to begin building up functionality within our app.

While there is a multitude of functions that exist within PowerApps, this chapter will focus on the more commonly used functions and look at how they can be used to create formulas. Many of the formulas will be illustrated using examples.

The following topics will be covered in this chapter:

• Using text functions to cast data and then perform a basic transformation on that text
• Undertaking mathematical calculations using arithmetical functions
• Working with dates, including getting the current date and time and formatting them
• Understanding conditional logic and how you can define branches...