Microsoft Power Fx Reference

ajo3403
2 min readApr 30, 2023

--

Power Fx.. low-code language that’s used across Microsoft Power Platform for expressing logic and the inspiration….Microsoft Excel. Since March 2021 Power Platform embraced Power Fx.

Microsoft Learn already has a comprehensive documentation around Power Fx. So what’s the intention of this Article?

Cheat Sheet for Power FX.. Intention is to show the functions with description, syntax and example, by rendering them on a Canvas App. There are more than 150+ Power Apps functions, hence this series will be segregated into multiple posts covering different functions.

In this article we will look into :

  1. Abs, Exp, Ln, Power, Log and Sqrt Functions
  2. Acceleration, App, Compass, Connection, and Location signals functions

Abs, Exp, Ln, Power, Log and Sqrt Functions
Calculates absolute values, logarithms, square roots, and the results of raising e or any number to specified powers.

Acceleration, App, Compass, Connection, and Location signals
Returns information about the app’s environment, such as where the user is located in the world and which screen is displayed.

Tips:
Acceleration.X > 0 being true will detect a mobile device as opposed to a PC.

We will look into more functions in the next article with various examples.

Happy Learning..!!

--

--

ajo3403
ajo3403

Written by ajo3403

Microsoft 365 | Power Automate | Power Apps | SPFX | ReactJS