Microsoft Power Fx

Print Print
Reading time 4:15

Microsoft Power Fx
ParadigmLow-code, general-purpose, imperative, strongly typed, declarative, functional
Designed byVijay Mital, Robin Abraham, Shon Katzenberger, Darryl Rubin
First appeared2021 (2021)
Typing disciplinestrong
LicenseMIT License
Influenced by
Excel functions, Excel macros, Pascal, Mathematica, Miranda

Microsoft Power Fx is a free and open source low-code, general-purpose programming language for expressing logic across the Microsoft Power Platform.[1][2]

The programming language was first announced at Ignite 2021 and the specification was released in March 2021.[3][4] It is based on spreadsheet-like formulas to make it accessible to a large number of people.[5] Power Fx was also influenced by programming languages and tools like Pascal, Mathematica, and Miranda.[6][7]

As Microsoft describes the language, it heavily borrows from the spreadsheet paradigm. In a spreadsheet, cells can contain formulas referring to the contents of other cells, and if the user changes the content of a cell, the values of all dependent cells are automatically updated. In a similar fashion, the various properties of components in a Power Fx program are connected by formulas (whose syntax is very reminiscent of Excel) and their values are automatically updated if changes occur. For instance, a simple formula might connect the color property of some component to the value of a slider component, and if the user moves the slider, the color will automatically change.[8]

The Power Fx language was developed by a team at Microsoft led by Vijay Mital, Robin Abraham, Shon Katzenberger and Darryl Rubin.[7] It is open source released under MIT License and is under active development on GitHub.[9]

See also


  1. ^ Anderson, Tim (2021-03-02). "Excel-lent: Microsoft debuts low-code Power Fx language... but it is not really new". The Register. Retrieved 2021-03-14.
  2. ^ Melanson, Mike (2021-03-06). "This Week in Programming: Microsoft's Power Fx 'Low Code' Language". The New Stack. Retrieved 2021-03-14.
  3. ^ Jawad, Hamza (2021-03-02). "Microsoft confirms the launch of Power Fx, its new low-code language". Neowin. Retrieved 2021-03-14.
  4. ^ Vizard, Mike (2021-03-08). "Microsoft Open Sources Low-Code Power Fx Language". Retrieved 2021-03-14.
  5. ^ Wyciślik-Wilson, Mark Sofia (2021-03-03). "Microsoft Power Fx is an open source, low-code programming language". BetaNews. Retrieved 2021-03-14.
  6. ^ Sarkar, Soumyadeep (2021-03-02). "Microsoft launches new low-code programming language Power Fx". The Tech Portal. Retrieved 2021-03-14.
  7. ^ a b Lardinois, Frederic (2021-03-02). "Microsoft launches Power Fx, a new open source low-code language". TechCrunch. Retrieved 2021-03-14.
  8. ^ "Microsoft Power Fx overview - Power Platform". 2021-02-26. Retrieved 2021-05-10.
  9. ^ "GitHub - microsoft/Power-Fx: Power Fx low-code programming language". GitHub.

External links

Edited: 2021-06-18 18:14:40