Article: Microsoft’s new Power Fx is an open-source language based on Excel

Code, Language, Open Data, Open Software, Open Source

Microsoft’s new Power Fx is an open-source language based on Excel

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.

Read Full Article

Article: Microsoft launches Power Fx, a new open source low-code language

Code, Language, Open Data, Open Software, Open Source

Microsoft launches Power Fx, a new open source low-code language

Microsoft today announced Power Fx, a new low-code language that takes its cues from Excel formulas. Power Fx will become the standard for writing logic customization across Microsoft’s own low-code Power Platform, but since the company is open-sourcing the language, Microsoft also hopes that others will implement it as well and that it will become the de facto standard for these kinds of use cases.

Since Power Platform itself targets business users more so than professional developers, it feels like a smart move to leverage their existing knowledge of Excel and their familiarity with Excel formulas to get started.

Read Full Article