Microsoft Power Fx is an open-source programming language that hopes to make coding as straightforward as building a spreadsheet.
Power Fx is described by Microsoft as a general-purpose, strong-typed, declarative, and functional programming language. It shares the same syntax and functions as Excel, with Microsoft explaining that Power Fx behaves much in the same way its popular spreadsheet application handles formulas.
This concept is at the core Power Fx: to make programming apps as easy as building a spreadsheet in Excel. Instead of having to grapple with multiple pieces of code, Power Fx leverages formulas, which are declarative and immediately recalculate as code is updated. This means any errors are detected and highlighted immediately and don’t interfere with the rest of the code.