Microsoft Debuts New Low-Code Language, Microsoft Power Fx

Introduced at Microsoft Ignite 2021, Microsoft Power Fx will allow end users to set up workflows and data management processes by using the same logical syntax found in Microsoft Excel.

Richard Hay, Senior Content Producer

March 17, 2021

2 Min Read
Microsoft Debuts New Low-Code Language, Microsoft Power Fx
Microsoft

At Microsoft Ignite 2021, the Redmond company took the low-code aspect of their platform to the next stage with the announcement of the Microsoft Power Fx programming language.

Last year when we profiled the low-code/no-code offerings from Microsoft, Amazon, and Google, it seemed that Microsoft’s service, based on their Power Platform, was one of the most robust. It has a broad range of capabilities to enable citizen developers to build out viable solutions that will increase the productivity of their business workflow.

The no-code/low-code trend has really become a mainstay over the last year during the COVID-19 pandemic. The idea is to drive development of apps and automation down to the employee level because they have intimate knowledge of their business processes.

Anyone who has used Microsoft Excel and is familiar with the format of formulas to build out data displays and content will find Microsoft Power Fx easy to adapt to because it is based on that Microsoft Excel formula language.

Microsoft’s Ryan Cunningham, who manages the program for Power Apps, shared what he called three exciting reasons about the availability of Microsoft Power Fx.

  1. It is an open-source language that will be available for community contributions on GitHub. (Reminder: Microsoft owns GitHub.)

  2. Since Microsoft Power Fx is based on Microsoft Excel, the use of formulas is second-hand to many users. Those skills will be immediately useful for anyone trying out Microsoft’s Power Fx.

  3. The Microsoft Power Apps canvas, i.e. a programming/development framework for low-code/no-code workflows, has already been using Microsoft Power Fx as its foundation. This new language will soon be made available for other Power Platform services such as Microsoft Dataverse, Microsoft Power Automate, and Microsoft Power Virtual Agents.

Cunningham stated that a low-code language is necessary because point-and-click platforms do well to establish quick workflow improvements with the Power Platform but there are many times when an extra layer of programming is necessary to further refine these solutions.

Because of its roots in Microsoft Excel, citizen developers who have familiarity with its formulaic syntax will easily transition to using that logical grammar in their Power Platform apps to make them even more effective solutions.

Additional Microsoft Power Fx Resources

Read more about:

Microsoft

About the Author(s)

Richard Hay

Senior Content Producer, IT Pro Today (Informa Tech)

I served for 29 plus years in the U.S. Navy and retired as a Master Chief Petty Officer in November 2011. My work background in the Navy was telecommunications related so my hobby of computers fit well with what I did for the Navy. I consider myself a tech geek and enjoy most things in that arena.

My first website – AnotherWin95.com – came online in 1995. Back then I used GeoCities Web Hosting for it and WindowsObserver.com is the result of the work I have done on that site since 1995.

In January 2010 my community contributions were recognized by Microsoft when I received my first Most Valuable Professional (MVP) Award for the Windows Operating System. Since then I have been renewed as a Microsoft MVP each subsequent year since that initial award. I am also a member of the inaugural group of Windows Insider MVPs which began in 2016.

I previously hosted the Observed Tech PODCAST for 10 years and 317 episodes and now host a new podcast called Faith, Tech, and Space. 

I began contributing to Penton Technology websites in January 2015 and in April 2017 I was hired as the Senior Content Producer for Penton Technology which is now Informa Tech. In that role, I contribute to ITPro Today and cover operating systems, enterprise technology, and productivity.

https://twitter.com/winobs

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like