Microsoft: to the javascript page, here is power fx with more powerful excel help

Microsoft: To the JavaScript page, here is Power FX with more powerful Excel Help

A new programming language called power fx has presented microsoft to his home trade show ignite. It is a free low code tool that does not focus on classic developers, but regular office users. And the latter witness, because power fx is based on excel.

Specifically, it uses the same syntax as excel, with which many users have already been familiarized and with which they could still write complicated applications than with simple drag-drop tools. At the start, canvas apps can be created, but microsoft plans to extend the language to other areas of the power platform – including dataverse, power automate and power virtual agents.

Microsoft: To the JavaScript page, here is Power FX with more powerful Excel Help

The necessary code of power fx and javascript in comparison.

On request the complete code

Users should merely have to specify what their application should do without defining how to work. As in excel, declarative formulas change changes to other places of the application automatically, variables and data tables must not be updated handically updated. Programmers can also use power fx in a classic ide like visual studio code and edit the complete source code there.

The choice of excel as a template happened according to the envision of the new tool due to the existing user base: with hundreds of millions of users, the syntax is already widespread and known. Even the most popular programming language javascript is currently only 11.7 million more or less active developers. Microsoft provides power fx as free software under the with license, the repository can be found on github.