Contact Us Today!

What is Power Fx?

What is Power Fx?

If you've been keeping up with the sweeping changes happening around the Microsoft Power Platform, you're probably familiar with the term Power Fx.  It's mentioned throughout Microsoft's more modern documentation, and you've likely seen some areas in your configuration components that accept custom Power Fx scripts.

What is Power Fx?

Put simply, Power Fx is a coding language.  Don't worry, this language is not nearly as complicated as JavaScript, C# or the like.  Power Fx is more like Excel formulas; in fact, excel formulas are exactly what Microsoft based this new language off of!  Power Fx is considered a "low-code" language, which means there is less you need to learn to get started with it, albeit with less capability for complex functions.

An Approachable Language

In typical programming languages, there are a lot of steps to performing a piece of logic.  Let's say you want to add two numbers together to update a 3rd number, like this:

A + B = C

With other languages, you would need to:

  1. Define the 3 variables above
  2. Pass values to these variables, typically using an API (an entirely different set of code)
  3. Add "A" and "B" together, set the value of "C"
  4. Use an API call to Update a record with the value of "C"

Power Fx reduces this down to a single step!  Editors within your app understand what values are being defined, because they are based on your table's schema.  This eliminates steps 1 and 2.  Power Fx also knows what column and row you want to update, again using your table's schema.  This eliminates step 4.  This low-code approach takes out most of the overhead in using a typical programming language.  What's left is a powerful, functional coding language that you can learn, especially if you already know your way around excel formulas.

Where can I learn Power Fx?

I highly recommend checking out Microsoft's documentation covering everything you need to know about Power Fx.  Check back here for updates and examples, which we'll cover in future blogs.

Contact Beringer Today!

We love to implement the Power Platform and Microsoft Dynamics 365 here at Beringer.  We’ve been working with Microsoft Dynamics since its inception, and we’re always finding innovative ways to implement the latest tools and help automate business processes.

Beringer Technology Group, a leading Microsoft Gold Certified Partner specializing in Microsoft Dynamics 365 and CRM for Distribution also provides expert Managed IT ServicesBackup and Disaster RecoveryCloud Based Computing, Email Security Implementation and TrainingUnified Communication Solutions, and Cybersecurity Risk Assessment.


theProfessor

theProfessor

Rob is the CTO of Beringer Technology Group, and focuses his efforts on software development, cloud engineering, team mentoring and strategic technical direction. Rob has worked with Beringer since 2005, and has influenced every department from Development, Security, Implementation, Support and Sales. Rob graduated with his MBA from Rowan University in 2012, earned his Bachelors of Computer Science in 1997, and is current with several Microsoft technical certifications. Rob is very active, and loves to mountain bike, weight train, cook and hike with his dog pack.