Microsoft Power Fx

Microsoft Power Fx is a free and open source low-code, general-purpose programming language for expressing logic across the Microsoft Power Platform. It was first announced at Ignite 2021, and its specification was released in March 2021. The language is built on spreadsheet-like formulas so that large numbers of people can use it: as in a spreadsheet, where cells hold formulas that refer to other cells and dependent values update automatically when one changes, the properties of components in a Power Fx program are connected by formulas whose syntax is closely modelled on Excel. A formula can, for example, tie a component's color to the value of a slider, so that moving the slider changes the color. Power Fx was also influenced by Pascal, Mathematica and Miranda. The original formula language came from a Microsoft team led by Vijay Mital, Robin Abraham, Shon Katzenberger and Darryl Rubin as part of the Tangram and Siena projects, and Greg Lindhorst and Mike Stall later led the work that turned it into Power Fx as part of Power Apps. Microsoft shared the source code under the MIT license on 2 November 2021, after initially opening only the documentation, and in April 2024 added Copilot features that explain a formula and generate Power Fx from natural language.