We will learn to calculate logarithmic, absolute values, square root & exponential in Power Apps. Before we start, make sure to subscribe to CRM Crate so that you can stay up to date in the field of Power Apps.
What is Power FX?
Microsoft’s Power Fx is the low-code language that will be used across Power Platform. It’s a strong-typed, general-purpose, declarative, and functional programming language. Power Fx is expressed in user-friendly text. It’s a low-code language that citizen developers & makers can work with directly in an Excel-like formula bar or Visual Studio Code text window.
It enables a complete range of development from no-code for those who have never programmed before to “pro-code” for the seasoned professional, with no learning or rewriting cliffs in between, enabling diverse teams to collaborate and save time and expense.
It enables a complete range of development from no-code for those who have never programmed before to “pro-code” for the seasoned professional, with no learning or rewriting cliffs in between, enabling diverse teams to collaborate and save time and expense.
Understanding Abs( ) function
Abs( NumericalValue)
The Abs function returns the non-negative value of its argument. If a number is negative, Abs returns the positive equivalent.
Abs( -66)
Returns the number without the negative sign. The result is “66”.
Understanding Ln ( ) function
Ln( NumericalValue)
The Ln function returns the natural logarithm (base e) of its argument.
Ln( 100 )
Returns the natural logarithm (base e) of the number 100. The result is “4.605170…”.
Understanding Log() function
Log (Number, Base)
The Log function returns the logarithm of its first argument in the base specified by its second argument (or 10 if not specified).
Log( 100 )
Returns the logarithm in base 10 of the number 100. The result is “2”.
Log( 64, 2 )
Returns the logarithm in base 2 of the number 64. The result is “6”.
Understanding Power () function
Power( Base, Exponent )
The Power function returns a number raised to a power.
Power( 5, 3 )
Returns 5 raised to the power of 3, or 5 * 5 * 5. The result is “125”.
Understanding Sqrt () function
Sqrt (NumericalValue)
The Sqrt function returns the number that, when multiplied by itself, equals its argument.
Sqrt( 9 )
Returns the number that, when multiplied by itself, results in 9. The result is “3”.
Implementation of the above given Power FX formulas in Power Apps.
The above Power FX formula implementation is demonstrated in the below given animation.