Low-Code Programming Language Power Fx introduced by Microsoft

Low-code is a visual approach to software development. Low-code abstracts and automates every step of the application lifecycle to enable rapid delivery of a variety of software solutions. It breaks the traditional silos of business and IT to promote continuous collaboration.

 

Increased business demand for software solutions and a shortage of skilled developers have propelled the adoption of low-code development platforms to the forefront. As per Gartner, by 2024, low-code application development will be responsible for more than 65% of application development activity.

 

Technology, and the role it plays in the business landscape, is an ever-evolving juggernaut. Core systems and business challenges are progressively complex. The pace of that evolution increases exponentially - what is fast right now will be glacial in hindsight.

To keep up, you must build and deploy innovative, timely solutions. We believe that building solutions with low-code makes that possible. We believe software should be built well. We believe it should deliver business value. We believe it should be delivered at speed.

 

The reason why the importance of Low code getting important, a web-based portal is a great digital tool to deliver self-service experience. Customers can perform routine tasks like finding services, paying bills, getting a quote, and more without actually having to talk to you! For the companies, portals are a cost-effective way to provide consistent customer experience and add new revenue streams. Despite the value, a lot of companies struggle to launch a customer portal. Traditional development is slow and resource-consuming, while commercial-off-the-shelf (COTS) solutions aren’t differentiated enough to meet your unique needs.

 

Low-code solves these pain points by allowing developers in business and IT to collaborate and deliver customer portals-with consumer-grade UI-in a fraction of the time it takes with traditional development. Further, companies can build the interface once and reuse it multiple times for different purposes and devices.

 

To complement the growth, Microsoft has introduced the newest member of the Microsoft Power Platform family: Microsoft Power Fx, an open source formula language for low code that’s based on Microsoft Excel.

 

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, we’re 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.

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

 

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” the requires traditional code, often 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 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 20241.

 

From citizens to professionals

 

With Power Fx, we 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, we’re 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, we’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

 

Today we’re embarking on a journey to bring this familiarity and productivity to more places. Over the next 24 months, we’ll extend Power Fx 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.

 

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. 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