Microsoft Power FX: What is it and why is it important?

Maximize your business productivity
Are you looking to multiply your business productivity? Yes, you heard it right. This content piece is a walk-through around Microsoft Power FX and its impact. Microsoft Power FX was launched by Microsoft at the Microsoft Ignite, 2021. What is Power FX? Microsoft Power FX is the low code language for expressing logic across the Microsoft Power Platform. It is the same language that is at the heart of Microsoft Power Apps canvas apps today and is inspired by Microsoft Excel. It enables the full spectrum of development from “no code” to “pro code” with no cliffs in between, enabling diverse teams to collaborate and save time and expense.Source: What is Microsoft Power FX? | Microsoft Power Apps Microsoft is working closely to incorporate Power FX into Microsoft Dataverse, Model-driven Power Apps, and Microsoft Power Virtual Agents. It has also set-up a GitHub repository for open source at https://github.com/microsoft/Power-Fx where anyone can share their thoughts about the language. What’s changed and why is it important? Power FX is the name given to the expression language. The content becomes easier to search. The future of this language is that whenever there is a part of the Power Platform that does not have a native language then Power FX becomes its go-to language of preference. This means learning this language is vital to learning the Power Platform. Closely Connected to Excel Are you looking to build an app without difficulty as you build a spreadsheet? Microsoft Power FX is the answer. You can even take advantage of your present spreadsheet knowledge. Many such questions encouraged the formation of Power Apps and Power FX. Everyday billions of people are creating spreadsheets with Excel. Now leverage your excel skills in app creation. Reproducing Excel’s expression language for operators, core functions, and data types are fairly easy. The below table shows all of Power FX’s core functions, the ones marked in green are identical to Excel’s version.



- Refresh – to revive a data source
- Navigate – to move among screens
- Collect – to push data into an in memory table
- SubmitForm – to submit a form
- Reset – to reset a control
- Patch – to direct data to a data source

- Gallery1.Selected – returns a complete record
- Gallery1.Selected.Title – returns the value in the Title field
- TextBox1.Text – returns the text entered into a text box, and this is significant as if we wish to make use of it in a patch statement to create a new record then this is the expression that we would require.
- Power Virtual Agents
- Power Automate
- Dynamics/Dataverse calculated columns
- Portals
- M, or Power Query – Used for Load activities and Extract Transform
- DAX – Data Analysis Expressions used in Power BI