Microsoft Power Fx is new. However, anyone familiar with Excel, will recognise the interface. It is used for expressing logic across the Microsoft Power Platform. It supports all the development tools from “no code” to “pro code” within the formula based language.
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 the platform.
Simple — Power Fx was 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 will 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 fulfil. In this case, the programmers can edit the Power Fx formulas using YAML source files. There are many tools for this already available in the market.
Runs Asynchronous — Power Fx data operations are always async, and the 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 a functional approach instead of Object-Oriented. That does not mean Power Fx does not support it, and you can easily access the component’s methods and properties.