Introduction to Microsoft Power Fx

Rikin ShahMicrosoft Dynamics CRM Consultant
Microsoft Power Fx a new programming language?
Microsoft Power Fx is new. However, anyone familiar with Excel, will recognise the interface. It is used for expressing logic across the Microsoft Power Platform. It supports all the development tools from “no code” to “pro code” within the formula based language.

Microsoft Power Fx is a free and open-source low-code, general-purpose programming language for expressing logic across the Microsoft Power Platform. It is based on spreadsheet-like formulas.

Key Features of Microsoft Power Fx includes:

Open Source — being open-sourced means others can contribute to the platform.

Simple — Power Fx was designed in such a way that users do not need to be trained as developers

Based on Excel formulas — already popular to millions of its usability and how they work

Low Code and Unified Language — Unified language that will be used across all Power Platform apps. Most of the formulas are one-liners.

Pro Code — Business requirements are sometimes very tricky that Low Code language cannot fulfil. In this case, the programmers can edit the Power Fx formulas using YAML source files. There are many tools for this already available in the market.

Runs Asynchronous — Power Fx data operations are always async, and the user does not need to know programming concepts for it.

Instantly Calculated — Just like Excel spreadsheet, the data with formulas are instantly calculated when data is edited

Not an Object-Oriented Language — Power Fx and Excel both are not object-oriented. Power Fx uses a functional approach instead of Object-Oriented. That does not mean Power Fx does not support it, and you can easily access the component’s methods and properties.

Extensible and Developer Friendly — Developers can create their own components and functions by writing JavaScript. And unlike Excel formulas, Power Fx supports adding comments also.

Happy Power Fx-ing!!

References :
Rikin ShahMicrosoft Dynamics CRM Consultant

Comments (0)

Have a question about something in this article? You can receive help directly from the article author. Sign up for a free trial to get started.

Get access with a 7-day free trial.
You Belong in the World's Smartest IT Community