Microsoft’s Low-Code Programming Language Power Fx

Everything you need to know about Microsoft’s Low-Code Programming Language Power Fx

Author image By Tejas Patel  |  Wednesday, April 28, 2021 12:08 PM  |  3 min read  |   199

Power Fx

The announcement: 

In the recent event of Microsoft Ignite 2021, Charles Lamanna- The corporate vice president of the Redmond company took the low-code aspect of their platform to next level by introducing a new low-code programming language, Power FX. The announcement was during the ongoing session of “What’s new and next with Microsoft power platform”.

With the COVID-19 pandemic hitting the world hard, the no-code/low-code trends remain the mainstay since last year. The Power platform was considered to be the most robust due to its wide range of capabilities to enable citizen developers to build solutions that increase business workflow. The idea was to drive app development and automation down to employees as they have in-depth knowledge of their business process.

Behind Microsoft Power Fx – What makes it a highly flexible language?

Microsoft Power Fx is an open-source low-code programming language. It is a strong-type, general-purpose, declarative, and functional programming language that can directly edit apps in multiple text editors like Visual Studio Code, Excel, and alike formula bar.

According to Ryan, the Power Fx is built on a similar syntax that is used by millions of developers currently to solve computation and logic problems.

Amongst multiple features, some of the features include the ability to edit apps directly in text editors like visual studio code. It helps developers and professionals to go faster and find common attributes and variables with millions of makers.

Some of the intuitive features of this low-code language are

  • It is open-source: The tech giant and Microsoft experts have already made the language publicly available on GitHub. 
  • The language is based on Microsoft Excel: Incorporating Microsoft Excel formulas, Power Fx allows a wide range of people to leverage skills they already know to build low code solutions.
  • Power Fx is built for low-code programming: The Microsoft developers are planning to extend the use of the language across multiple platforms including Microsoft Dataverse, Microsoft Power Virtual Agents, Microsoft Power Automate, and beyond.
  • Local and remote: This low-code language makes use of the same syntax and functions for data, which is already local in-memory and remote in a database.
  • Strongly typed: Power Fx is a strongly typed language which means that all value types are recognized at compile time. This helps in detecting the errors and bugs at an early stage.
  • Asynchronous. Since all the data operations in Power Fx are asynchronous, developers do not need to specify this or neither synchronize after the call. It is fine if the developers are unaware of this concept.
  • Relational data. Consider Orders and Customers are two different tables with a many-to-one relationship. The OData query requires an “$expand” with a foreign key, similar to a Join in SQL. Though the formula has none of this, developers can make use of a simple dot notation to access the entire graph of relationships from a record.
  • Projection. While writing a query, many developers will write “select * from …” which triggers to bring back all the data columns. With Power Fx, it will analyze all the columns used through the entire app, even across formula dependencies. With this, projection is automatically optimized.

How does it work?

Based on spreadsheet-like formulas, Microsoft Power Fx is a low-code programming language. It binds the objects together with declarative spreadsheet-like formulas. The language is currently integrated into Power Apps canvas apps.

Code image

If you’re using this language, an expression by itself has no meaning. It is up to the developers, whether they want to place it as a variable or as a function. Furthermore, instead of writing an expression with no meaning, you can write a formula that binds an expression to an identifier.

Benefits of Power Fx

The language enables a wide range of development from “no-code” for those who aren’t familiar with the programming to “pro-code” for the professionals. There is no need for learning or rewriting cliffs in between which enables multiple teams to collaborate and work together to save time and expense.

Another benefit of Power Fx is that it works like a live worksheet with an incremental compiler that keeps the program in sync with its data operation in continuous mode. It also provides a rich editing experience with suggestions, autocomplete, IntelliSense, and type checking.

Wrapping up:

It is anticipated that Microsoft will expand its Power Fx’s features to add support for formula-based and model-driven app customization and dataverse plugins. By the end of this year, better support in terms of dataverse calculated columns, Power virtual agents, and AI builder data preparations is expected.

Microsoft’s Low-Code Programming Language Power Fx

Microsoft will expand its Power Fx’s features to add support for formula-based and model-driven app customization and dataverse plugins.

Contact Us


Author image

Tejas Patel

Tejas Patel is a Co-Founder of Concetto Labs and he have 18+ years of technical experience in building high quality and scalable Web & Mobile Applications.

Why Our Client Love Us?

  • Fast kick-off
  • Agile Ready
  • 98% Client Retention
  • 360-Degree solutions

Our integrity and process focuses largely on providing every customer the best recommendations for their respective business. Our clients become recurring customers because we always go beyond their expectations to deliver the best solutions.

Get In Touch
Mr. Sieva Savko
Customer for over 4 years Mr. Sieva Savko Norway

Concetto Labs have provided us with a tremendous amount of help. Their competence in various IT fields led to a positive outcome while facing different challenges. A lot of value was given by their helpful professional staff. To describe this company in three words: effectiveness, collaboration, trust. I would also like to personally thank Mr. Tejas Patel for his positive, friendly, and highly competent approach. The all-around support provided by him made every task at hand a no-brainer.

Miss. Caroline Jack
Customer for over 4 years Miss. Caroline Jack South Africa

It has been an absolute pleasure working with the Concetto Labs team! We have worked together on a few projects now, all of which have been successful. You can rely on good communication and response times from these guys. And they go above and beyond to ensure that the result is achieved. Because of their great service, they have become an integral part of our business and we will continue to use them going forward.

Mr. Richard Bartlett
Customer for over 3 years Mr. Richard Bartlett United States

Concetto Labs is a group of incredibly talented individuals. They are very responsive and communicate with you each and every step of the process. I worked with Manish Patel throughout the entire process and must say that I have never conducted business with a more honest and professional individual. Together with his team, Manish created exactly how we envisioned it to be. Thanks for all of your hard work.

Mr. Conrad Abraham
Customer for over 2 years Mr. Conrad Abraham United States

Concetto Labs team is my go-to for any simple or complex development projects. They have risen to the challenge. Great project management, communication, and super quick turnaround. I’ve done multiple projects with them and don’t plan on changing that.

Mr. Edward Chin
Customer for over 4 years Mr. Edward Chin Canada

Concetto Labs was able to bring my complex idea to life. Throughout the project, Concetto Labs maintained constant communications and was always professional - considering I had no experience in what I wanted to create their welcoming attitude, patience, and knowledge in the field created the perfect environment to work in. I was so impressed with their work that I've kept them on board as my go-to experts. Thanks for the worthwhile experience and the breathtaking product.

Karuna Govind
Karuna Govind CTO & Co Founder (Coupay) London, UK

We started working with Concettolabs due to the influx of work on mobile (Flutter) and frontend (React.js). It's been fantastic working with them. Good, consistent communication and good quality of work means they may be our first choice for many projects to come.

Arunabha Choudhury
Arunabha Choudhury Director (Fuzzann Technologies Private Limited) India

We are a healthcare IT company and wanted to build a Mobile Application for both Android and IOS using Flutter. The Concetto Lab team has been very patient with our project requirements and made sure all our queries are answered. It was a great show of professionalism and customer relationship. Even during the project, the team was very accommodating of all the changes we requested. The project was delivered successfully and we deployed the app in the Android Play Store. Overall, the entire process has been very transparent and the team was able to deliver exactly what we had envisioned the project outcome to look like.

Good Firms Clutch App Futura Microsoft Associate Mobile App Top Developers Gesia
Are you enjoying reading what you see?

Feel like discussing more about this with our Sales Experts? Click on Create Similar Button.