PL-900 EXAM TOPIC

BEGINNER FRIENDLY

~5 MIN READ

Most low-code platforms hit a wall the moment a maker needs to express real logic — and the maker either gives up or hands the project to a developer. Microsoft solved that wall by giving the Power Platform a single, familiar language: Power Fx. If you have ever written an Excel formula, you have already written Power Fx.

What Is Microsoft Power Fx?

Microsoft Power Fx is the low-code language used across the Power Platform to express logic — calculations, conditions, validation, navigation, and data lookups. It is based on the Microsoft Excel formula language, which is the most widely used “programming model” in the world.

Power Fx is general-purpose, strongly-typed, declarative, and functional, with imperative logic available where needed. It is open source on GitHub and is being extended across more Power Platform services with every release.

Key Concepts to Know

Excel-Inspired Formula Language

Power Fx uses the same syntax that Excel users already know. Functions like If, LookUp, Filter, and Sum, plus operators such as & for string concatenation, work the same way they do in a spreadsheet. Anyone who has written =SUM(A1:A10) already has a head start.

Declarative and Auto-Recalculating

Like Excel, Power Fx is declarative — makers describe what they want, not how or when to do it. When a value changes, dependent formulas recalculate automatically.

Where Power Fx Is Used

• Power Fx originated in canvas apps in Power Apps and is expanding across the Power Platform.
• It is primarily used in canvas apps to define user interface behavior, navigation, validation, and data operations.
• It is also used in Microsoft Dataverse for formula columns that provide server-side calculated values, and is being introduced in other areas such as Copilot Studio and parts of Power Automate.

No-Code to Pro-Code Without a Cliff

Power Fx is designed to support the entire spectrum: from non-developers building their first app to professional developers writing complex formulas in Visual Studio Code. Both groups speak the same language, which makes citizen-developer / pro-developer collaboration much easier.

Open Source

Power Fx is an open-source, Excel-like formula language developed by Microsoft and available on GitHub, with ongoing development led by Microsoft.

The Business Value

• Familiar — based on Excel, the world’s most widely used spreadsheet and “programming model.”
• Low barrier to entry — non-developers can express complex logic without learning a traditional programming language.
• Consistent across the platform — the same language, where supported, in canvas apps, formula columns, desktop flows, and more.
• Declarative recalculation — changes ripple through the app or table without manual event-handler code.
• Strongly-typed — reduces bugs by validating types at design time.
• Open source — backed by Microsoft and a growing community on GitHub.

Common Use Cases

Scenario	Solution Using Power Fx
Calculate a total in a canvas app	Bind a label to Price * Quantity * (1 – Discount)
Show a control only when a value is selected	Set Visible to !IsBlank(Dropdown1.Selected.Value)
Build a full name in a Dataverse formula column	Concatenate(FirstName & ” ” & LastName)
Filter a gallery by a chosen category	Filter(Products, Category = Dropdown1.Selected.Value)
Validate input before submitting	If(IsBlank(Email), Notify(“Enter email”, Error), Submit(Form))

Quick Reference

Feature	What to Know
Definition	Low-code, general-purpose language for expressing logic across Power Platform.
Based on	Microsoft Excel formula language.
Type system	Strongly-typed, declarative, and functional, with imperative logic when needed.
Where it is used	Canvas apps in Power Apps, Dataverse formula columns in Microsoft Dataverse, and some model-driven app scenarios.
Recalculation	Automatic — like a spreadsheet, formulas re-evaluate when values change.
Skill range	No-code to pro-code without a learning cliff.
For PL-900	Recognize what Power Fx is and where it is used; you don’t need to write it.

Keep going on your PL-900 journey If this helped, save it for revision and explore the rest of the series. #PL900   #PowerPlatform   #PowerFx   #LowCode   #MicrosoftLearn

PL-900 EXAM PREPARATION  ·  MICROSOFT POWER PLATFORM FUNDAMENTALS