Power Apps Formula Reference Cheat Sheet

We’ve all seen first-hand that the extent of Power Apps lies in its ability to handle complex formulas. Anything from setting variables and building collections to relational table lookup or complex math. However, knowing what formula to use, when to use it and how to use it can often result in lengthy google searches or spending too much time watching YouTube videos.

As a Power Platform Developer for over 2 years, I still find myself forgetting how to use certain formulas but correctly, when and where to use them. This is where the Formula Reference for Power Apps always saves the day.

The Formula Reference for Power Apps is lengthy documentation provided by Microsoft that many don’t know exists, but it is a resource I turn to whenever I’m building Power Apps.

Have a complex math problem you want to solve? All of the formula available in Power Apps is made available in this documentation and comes complete with an in-depth knowledge base explaining what it does, and how to use it and includes examples and code snippets, with results so you can see what your outcome should be.

This is definitely one to add to your bookmarks if you struggle with Power Apps formula and want to take control of your expressions & syntax.


About the author 

Connor Deasey (Collab365)