Home » News Stories » MS Ignite: Launch Low-code Power Fx

News Stories

Job Search


Back to News »

MS Ignite: Launch Low-code Power Fx

Share this:
digg it  | kickit | Email it | | reddit | liveIt
Subscribe to IrishDev News RSS 
DateFriday, March 05, 2021
AuthorRyan Cunningham Director PM, Power Apps /

MS Ignite News: Launching the Low-Code Power Fx

Grounded on Microsoft Excel This Open Source Language Allows Users to Begin Low-code Developments with Relative Ease

Ryan Cunningham Director PM, Microsoft Power FX. Grounded on Microsoft Excel this Open Source language allows Users to begin their low-code developments with relative ease.

Microsoft has published its first open-source low-code programming language, Microsoft Power Fx, for logic customization across the Power Platform. Expressed in text, this low-code language, leverages the knowledge of Excel users to reduce barriers for citizen developers getting started with low-code development, whilst professional developers can accelerate their app development with the simplicity of formulas and code using their favorite pro developer tools.


Currently Power Fx is used as the language to develop canvas apps in Microsoft Power Apps, and will eventually become the consistent language across the Power Platform.


Power Fx is exciting for three key reasons:

Power Fx is open source. The future of programming is open. Microsoft has embraced the pace of open innovation that has accelerated the adoption of languages like C# and Typescript. With Power Fx, Microsoft is now bringing that same open approach to the low code world. Microsoft will open-source Power Fx, making the language available for open contribution by the broader community on GitHub later in 2021.


Power Fx is based on Microsoft Excel. Using formulas that are already familiar to hundreds of millions of users, Power Fx allows a broad range of people to bring skills they already know to low code solutions. Power Fx becomes a common ground for business users and professional developers alike to express logic and solve problems.


Power Fx is built for low code. Power Fx is already the foundation of the Microsoft Power Apps canvas. We’ll soon extend its use across Power Platform to Microsoft Dataverse, Microsoft Power Automate, Microsoft Power Virtual Agents, and beyond, making it even easier for everyone to get started with low code tools.


Low code logic for everyone  

So why does a low-code platform need a language? The truth is, point-and-click tools are great for quickly assembling experiences and workflows, but many real-world solutions need a layer of logic that goes beyond what is practical to drag and drop, for example:

Show a list of customers who signed up in the last 7 days within 15 miles of this location.

Highlight the newest entries in green.

When a user clicks for more details, if the record has outstanding action items associated with it, pop those to the top of the screen.


This type of custom logic is where many low-code platforms have classically “hit a cliff”, often requiring traditional code, perhaps in proprietary formats with limited extensibility and a niche set of specialists. Power Fx, by contrast, is rooted in Excel—built on the exact syntax that hundreds of millions of people are already using to solve everyday problems of logic and computation.


To put the magnitude of Excel users in perspective, analysts at IDC estimate in their IDC, PaaSView and the Developer 2020: Focus Topic Pivot Table — Worldwide, Doc # US46800820, September 2020, that the most popular coding language, JavaScript, is used moderately or heavily by 11.7 million software developers today. The same report forecasts that the total population of full-time professional developers will grow 32 percent to 19.4 million by the year 2024.


Stack and Co. Hiring Software Developers Nationwide


From citizens to professionals

Microsoft suggest Power Fx can amplify the impact of developers by many multiples over the same time horizon. By offering citizen developers a familiar and approachable way to express logic, they are dramatically expanding who can build sophisticated solutions. By delivering Power Fx with the tools a professional expects, including the ability to directly edit apps in text editors like Visual Studio Code and use source control, they're making it possible for developers to go faster and find common ground with millions of makers.


Power Fx doesn’t just share the same syntax and functions as Excel, it also behaves in a familiar way. Like Excel, formulas are declarative and recalculate instantly just as a spreadsheet does.

Makers have the advantage of telling the app what they want it to do without having to describe the how or when—Power Fx does that for you, freeing developers from the tedious task of keeping variables and data tables up to date manually. With traditional programming languages, it can be challenging to understand all the pieces of code that impact a variable, but with formulas, there is only one way a value is calculated, ensuring everyone is working from the same source of truth.


The Next Chapter for Low-code Innovation is Open 

This next chapter is an exciting step in a software project that has a rich history at Microsoft. The origins of Power Fx run deeper than the platform itself. Microsoft is embarking on a journey to bring this familiarity and productivity to more places. Microsoft Power Fx is available now, with implementation being open sourced on GitHub later this year. Over the next 24 months, Power Fx will be extended as a singular consistent language across the breadth of Power Platform. This will make it even easier for makers to transfer their skills from being an app maker to being an intelligent bot builder to an automation expert seamlessly.


Founding Team

With investment spanning seven years across two project code names, Tangram and Siena, the language was originally brought to life by a team of architects and engineers led by Vijay Mital, Robin Abraham, Shon Katzenberger and Darryl Rubin. With a PhD in functional languages, extensive experience in AI, expression syntax, and Excel and programming, the team took inspiration from linear solvers, Miranda, Mathematica, and Pascal, and collectively leveraged the best of Microsoft to create a low-code language.


The founding team’s original aspiration was to craft a language that achieved three things:

Already familiar to the many millions of Excel users

Content-centric, not program-centric, generalizing not just numbers but all information with friendly naming conventions

Instantly calculated, recompiling in real time as edits are made, just like a spreadsheet, instead of requiring multiple steps to compile and publish.


Emerging at the epicenter of the low-code movement, Power Fx has achieved all this and more,  extending the language to work over hundreds of external data sources, across mobile device capabilities, and through advanced application scenarios. And we’re just getting started. Inviting the community to create with us through an open source strategy will be crucial to taking low code to the next level.


To learn more and get hands on with the details, Greg Lindhorst, who has been driving the Power Fx language forward since 2015, has an excellent deep dive blog post, “What is Microsoft Power Fx?”


This article was published by Ryan Cunningham, Director PM, Power Fx, on the Microsoft Blog and edited (only a little) by (Want to contribute? Check out our Guest Writers section)


Dublin City Centre Coworking


Our subscribers are also reading....

Related: MS Ignite News

Related: Low-code / No-code News, Events, Jobs


Corporate Information



Get Instant Irish Tech News Updates on our Social Channels....

Join at Facebook Join at LinkedIn Follow IrishDevdotcom on Twitter

Got a Story – Share it with the Irish Software Community – Email us at

Back to News »
digg it  | kickit | Email it | | reddit | liveIt | RSS
Low Cost, No Frills Coworking and Hotdesks
Unix Tutorials