Microsoft Extends its Low-Code Programming Language Push with Power FX

Author image By Dimpi Sheth  |  Thursday, May 13, 2021 03:45 PM  |  4 min read  |   1560

low-code Power fx

The recent Microsoft Ignite event has amazing news for the Microsoft developers. Charles Lamanna, the corporate vice president of the Low code Application platform announced Microsoft Power Fx – A new low-code programming language. This announcement is made during the session on “What’s new and next for the Microsoft power platform.

So, what’s behind Microsoft Power Fx?

Being an open-source language for low-code name language, Microsoft Power Fx is a strong-typed, declarative, and general-purpose functional programming language. It can directly edit apps in text editors like Excel-like formula bar or visual studio code. It is built on the similar syntax used by millions of developers to solve logic and computational problems. The language’s core features like the ability to edit applications directly in the text editor like visual studio code aid developers and skilled professionals to move faster. It helps them to find common grounds with millions of other developers – Says Cunningham Code image

What makes this low-code Power fx pack different from the earlier one?

Some of the lucrative features of this low-code programming language are 1. An Excel-based language: Supported by Microsoft excel formulas, Power Fx allows a broad range of new developers to bring in skills for low code solutions. 2. It is open source:  Since tech giants have made language available on GitHub publically, it is open source. 3. Strongly typed: Power Fx is strongly typing, meaning the types of all the values are already known at compile time. This helps in detecting the errors at an early stage. 4. Local and remote: This low-code language utilizes the same functions and syntax for the data available local in-memory and remote in the database. 5. Built for low-code programming: The Microsoft developers are shortly going to extend the use of this language across multiple Power platforms. It includes Microsoft power virtual agents, Microsoft Dataverse, Microsoft power automate, and beyond.

How Microsoft Power Fx works?

Microsoft Power Fx is a low-code programming language based on spreadsheet-like formulas. Power Fx binds objects together with declarative spreadsheet-like formulas. The language is currently integrated into Power Apps canvas apps. Code image In this language, an expression by itself means nothing about what it is calculating. But it is up to the developers, whether they want to place it in a variable or pass it to a function. Furthermore, instead of writing an expression with no specific meaning, one can write a formula binding the expression to an identifier.

What are the benefits of using Power Fx?

The language helps developers with a wide range of development. Right from “no-code” for those who are new to the programming to “pro-code” for the skilled and experienced professionals. It eliminates the need for learning or rewriting cliffs in between. And thus, enables multiple teams to collaborate and work together to save time and expenses. The other benefit of Power Fx is that it works like a spreadsheet that always remains alive and active. A compiler can keep the program in sync with its operating data in a constant way. The incremental compiler will provide a rich formula bar and editing experience with IntelliSense, type checking, autocomplete, and suggestions.

What does the future hold?

The developers announce that by the end of the year 2021, the Power Fx packs will be available for Dataverse calculated columns and the Power Fx formulas. It will be leveraged in AI by embedded into the AI builder data prep and Power virtual agents. A Microsoft low code chatbot platform. Though the low-code platform is emerging slowly, developers would be able to use it directly in the text editors like visual code. On the GitHub platform, Microsoft has already started dumping information on the Power FX. It has all the relevant examples of the documents to use grammar and expressions.

Wrapping Up

It is forecast that Microsoft will expand its Power FX’s features. It will add support for formula-based model-driven app customization and Dataverse plugins in June. The end of this year expects to bring more support. Along with Dataverse calculated columns, power virtual agents and AI builder data prep.

What Are The Benefits Of Using Power Fx?

Power Fx is that it works like a spreadsheet that always remains alive and active. A compiler can keep the program in sync with its operating data in a constant way. Contact Us

Develop an Application to Fulfill all Your Requirements and Get ready to Compete in the Market!

Get In Touch With Us!


Author image

Dimpi Sheth

I have been part of Concetto Labs since last year and it has been an exciting journey till now. I joined as Senior Powerapps Developer. Aside from Powerapps development, I have an experience in .NET and Angular. I always believe in learning something new every day. Concetto Labs providing me that opportunity and it excites me at work every day.

Why Our Client Love Us?

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.


We brainstorm a lot!

Because brainstorming leads to new thoughts & ideas. We believe in discussing & bridging the gap leading to nicer suggestions & application.


Believe in Innovation!

Innovation is like Jugaad. It only comes when you give it a try. We believe that extraordinary things come with innovation which help you stand & lead in the crowd.


Creative Developers!

Our developers are always keen to develop creative ideas. There is “NEVER a NO.” They have an eye on the market facts, thus develop in the latest on going environment.


Value for Money!

We understand the value of money & thus with a modular approach serve you the best quote for your application & web services. The features we promise, we deliver. #notohiddencosts

Trusted By

MB Aerospace
intercontinetal Hotel & Resort