Microsoft Rolls Out Power Fx : Low-Code Language Based On Excel

Microsoft has planned to extend Power Fx as a singular consistent language across the breadth of Power Platform.

Recently, Microsoft announced Power Fx, a new low-code language that takes its cues from Excel formulas.

The latest member of the Microsoft Power Platform family - Microsoft Power Fx - is an open-source formula language for low code that’s based on Microsoft Excel.

Microsft said that Power Fx is already the foundation of the Microsoft Power Apps canvas. The company will soon extend its use across Power Platform to Microsoft Dataverse, Power Automate, Power Virtual Agents, and more, making it even easier for everyone to get started with low code tools.

Well, Power Fx, by contrast, is rooted in Excel—built on the exact syntax that you already use to solve everyday problems of logic and computation.

Source: Microsoft

The company said that by offering a familiar and approachable way to express logic, Microsoft is dramatically expanding who can build sophisticated solutions. "By delivering Power Fx with the tools a professional expects, including the ability to directly edit apps in text editors like Visual Studio Code and use source control, we’re making it possible for developers to go faster and find common ground with millions of makers." wrote Microsoft.

In the next 24 months, Microsoft has planned to extend Power Fx as a singular consistent language across the breadth of Power Platform.

According to the company the founding team’s original aspiration was to craft a language that achieved three things: already familiar to the many millions of Excel users; Content-centric, not program-centric; and instantly calculated, i.e. recompiling in real-time as edits are made, just like a spreadsheet.

Microsoft has set up a GitHub repository for open source at https://github.com/microsoft/Power-Fx where you can begin to learn and share your thoughts about the language. 

To learn more you can visit the official blog on Power Fx here.