Blog

What is Microsoft Power Fx?

What is Microsoft Power Fx?

DynamicallyShort|Jul 23, 2024|, , ,

Microsoft Power Fx is a low-code, open-source language that powers logic across the Microsoft Power Platform. Similar to – and inspired by – Excel formulas, it enables Power Apps development of canvas apps and enhances the capabilities of model-driven apps; it is also used by Power BI, Copilot Studio, and Power Automate.

Power Fx and Canvas Apps

Power Fx is akin to the electrical conduit in your home or office – it’s what powers your app and makes it functional. Power Fx drives your app’s logic and supports the way screens and components interact with one another. When you build a canvas app, you will be relying heavily on Power Fx to make your app work the way you want it to.

Power Fx and Model-Driven Apps

Model-driven apps come prebuilt with all of the logic needed to handle how Dataverse tables interact with one another, which is highly beneficial in terms of ALM. However, Power Fx can be used to enhance model-driven apps in very useful ways, such as adding custom command bar buttons or creating calculated columns.

Sample Power Fx Code

Below are a few samples of how Power Fx code looks from a developer’s perspective:

Filter('Table1', StartsWith('fullname', "Yvonne"))

This code returns all records in Table 1 where the fullname column begins with “Yvonne.”

Sum('Field1','Field2',Field3')

This code returns the sum of Field1, Field2, and Field3.

ThisItem.'Created On'

This code locates the data source of the Items property of a canvas app component and sets the field to that data source’s Created On value.

Contact Beringer Today!

We love to implement Microsoft Dynamics 365 and Power Platform solutions here at Beringer.  We’ve been working with Microsoft Dynamics since its inception, and we’re always finding innovative ways to implement the latest tools and help automate business processes.

Beringer Technology Group, a Microsoft Solutions Partner for Business Applications, specializing in Microsoft Dynamics 365 and CRM for Distribution also provides expert Managed IT Services, Backup and Disaster Recovery, Cloud Based Computing, Email Security Implementation and Training, Unified Communication Solutions, and Cybersecurity Risk Assessment.