Mar 03, 2021 11:50:00

Microsoft develops low code 'Power Fx' that can be used like Excel

On March 2, 2021, Microsoft announced that it has developed a

low-code platform ' Power Fx ' that allows you to write code as if you were using Excel. Power Fx is on GitHub as open source the public has been.

GitHub --microsoft / Power-Fx: Power Fx low-code programming language
https://github.com/microsoft/power-fx

What is Microsoft Power Fx? | Microsoft Power Apps
https://powerapps.microsoft.com/en-us/blog/what-is-microsoft-power-fx/

Introducing Microsoft Power Fx: the low-code programming language for everyone | Microsoft Power Apps
https://powerapps.microsoft.com/en-us/blog/introducing-microsoft-power-fx-the-low-code-programming-language-for-everyone/

Power Fx is the standard method for coding on the application development platform '

Power Platform' provided by Microsoft. The user can code as if to type a function in Excel, and it is said that it is a specification like REPL where recalculation is performed at the same time as rewriting the code.

The functions that can be used with Power Fx are as shown in the image below, and the ones painted in green are the same as or similar to the functions that work in Excel.

'PowerFx has been developed to be built on an Excel-like syntax so that it can be picked up by Excel users who are already in use by hundreds of millions of people,' the development team said. Power Fx works in a way that Excel users are accustomed to, so even users who have had difficulty developing programs can seamlessly move to program development.

Power Fx was developed not only by Excel but also by Pascal and Mathematica . The development team wants a large number of users to use PowerFx and build a community, and says it will continue to improve in the future.