Introduction to Microsoft Power Fx

Rikin Shah
2 min readMar 22, 2021

Microsoft Power Fx is nothing new but the name of the formula language which is being used in Microsoft Power Platform.

Microsoft Power Fx is a free and open source low-code, general-purpose programming language for expressing logic across the Microsoft Power Platform. It is based on spreadsheet like formulas.

Key Features of Microsoft Power Fx includes:
Open Source — being open sourced means others can contribute to it

Simple — Power Fx is designed in such a way that users do not need to be trained as developers

Based on Excel formulas — already popular to millions of its usability and how they work

Low Code and Unified Language — Unified language that is going to be used across all Power Platform apps, most of the formulas are one liners.

Pro Code — Business requirements are sometimes very tricky that Low Code language cannot fulfill. In this case the programmers can edit the Power Fx formulas using YAML source files and many tools for this are already available in the market.

Runs Asynchronous — Power Fx data operations are always async and user does not need to know programming concepts for it

Instantly Calculated — Just like Excel spreadsheet, the data with formulas are instantly calculated when data is edited

Not an Object Oriented Language — Power Fx and Excel both are not object oriented. Power Fx uses functional approach instead of Object Oriented. That does not mean Power Fx does not support it, you can easily access component’s methods and properties.

Extensible and Developer Friendly — Developers can create their own components and functions by writing JavaScript. And unlike Excel formulas Power Fx supports adding comments also.

Happy Power Fx-ing!!



Rikin Shah

Solution Architect — Dynamics 365/CRM and other related technologies