Microsoft debuts Power Fx, a new open source low-code language that takes its cues from Excel formulas and will become a standard for Microsoft's Power Platform
Power-Fx/docs/overview.md … Microsoft Power Fx overview Mark Sofia Wyciślik-Wilson / BetaNews : Microsoft Power Fx is an open source, low-code programming language Mike Wheatley / SiliconANGLE : With Power Platform updates, Microsoft doubles down on low-code app development Mayank Sharma / TechRadar : Microsoft has created a whole new programming language for low-code BeauHD / Slashdot : Microsoft Launches Power Fx, a New Open Source Low-Code Language Steve Clarke / Windows Blog : Download Power Automate Desktop for Windows 10 to automate tasks and processes at no additional cost
Context & Ripple Effects
Power Fx is the language layer of a stack Microsoft has been assembling for five years: the 2016 public preview of PowerApps started the business-app push, Dataflex added a relational database for Teams-built apps in 2020, and two months after this announcement GPT-3 arrived in Power Apps to turn plain English into code (natural-language-to-code in low-code Power Apps). Making an Excel-formula dialect open source and naming it the Power Platform standard turns that stack into a coherent product line with one syntax across apps, automation, and chatbots.
The Excel hook is the strategic point rather than a branding flourish: it recruits the world's largest population of formula writers as an addressable developer base, and open-sourcing the spec lowers the adoption risk that usually kills proprietary low-code languages.
First-order effects
- Excel-literate business users gain a supported on-ramp into Power Platform development without learning a general-purpose programming language, and every Power Platform component — Power Apps, Power Automate, Power Virtual Agents — now converges on one shared expression syntax.
- Open-sourcing the language spec lets third-party tools and ISVs implement Power Fx-compatible editors and runtimes outside Microsoft's own surfaces, which Microsoft accepts deliberately to speed standardization.
Second-order effects
- Rival low-code platforms face pressure to answer with their own approachable expression languages or deeper natural-language authoring — a race Microsoft has already seeded by putting GPT-3 inside Power Apps, where generated code lands in Power Fx rather than raw JavaScript.
- The Excel skill base becomes a distribution channel: organizations that already pay for Office get incremental app-development capability at near-zero retraining cost, squeezing standalone no-code vendors whose value proposition was accessibility alone.
Third-order effects
- If the pattern holds, application development bifurcates between a professional tier writing general-purpose code and a mass tier composing formulas and prompts — with the low-code language, not the IDE, becoming the platform lock-in point, which is why open sourcing the spec matters more than open sourcing the runtime would.
- Natural-language codegen and a formal low-code language are converging into one pipeline — English in, typed expressions out — making whoever owns the target language the de facto compiler vendor for citizen development, a role Microsoft is positioning Power Fx to hold.
The trend: Enterprise software platforms are consolidating around spreadsheet-literacy-based low-code languages, with open specs used to recruit users and AI code generation layered on top as the new authoring interface.