Last week Microsoft made many announcements on Power Apps. One of the most important was naming Power Fx, the unified language used in Power Apps Canvas Apps and other Power Platform products. This announcement is more than just naming a language because it unveils a long-term plan for standardizing the Power Platform stack of development tools.
April Dunnam of Microsoft provides a concise explanation in the video above, relating the announcement to the groups of products and developers who are affected by the change.
Formulas in Power Apps are based on Power Fx which uses expressions derived from Microsoft Excel. Power Fx is easier to learn than JavaScript. It gives immediate results (or error messages) to the developer in a similar way to Excel. The following shows functions highlighted in green which are shared by Power Fx and Excel.
Source: https://powerapps.microsoft.com/en-us/blog/what-is-microsoft-power-fx/
Microsoft is targeting citizen developers or power users as a key segment of people who, in addition to other software developers, will create Power Apps solutions. These users, perhaps more than other software developers, are likely to be familiar with Excel functions.
Some Power Fx expressions are more concise than equivalent functions in JavaScript.
By the end of 2021, Microsoft will be rolling out standardization on Power Fx for Dataverse calculated columns, AI Build, and Power Virtual Agents. Subsequently the language will be standardized for Dataverse business rules and Power Automate.
For a more detailed explanation of Power Fx, see the video from Rory Neary:
For more on Power Apps, see related posts from this blog:
The Enduring Appeal of Low Code Software Development
6 Reasons to Choose Microsoft for your Low Code Application Platform
Energize your Intranet with Microsoft Power Apps and Customer Voice
Replacing Microsoft InfoPath with Power Apps
Power Apps Portal: The Successor to Microsoft Dynamics Portal
Governing the Dataverse: Peaceful Living with Microsoft Power Apps
Microsoft Power Apps for Nonprofits and the Dynamics 365 Nonprofit Accelerator
Dynamics 365 Power Apps: When You Want CRM Power without Sales, Customer Service or Marketing