Skip to content
    Microsoft Power Fx
    Power Platform

    Microsoft Power Fx

    The Excel-familiar formula language your business users already know.

    Excel-likefamiliar formula language
    Typedcompile-time & autocomplete
    Asyncnetwork calls built-in
    PortableApps, Automate, Pages

    Power Fx is the low-code formula language of the Power Platform. If you can write Excel formulas, you can build Power Apps logic — the same dialect, the same syntax. Power Fx runs in Canvas apps, Power Pages, Dataverse columns, and Power Automate.

    What matters for Theia: your business teams can make small adjustments themselves, without calling in developers every time. That reduces time-to-change and takes pressure off IT.

    Key Features

    What it does

    Excel-like syntax — familiar to business users

    Typed, with autocomplete and compile-time checks

    Async functions for network calls, natively supported

    Portable across Power Apps, Pages, and Automate

    Open source — MIT-licensed, viewable on GitHub

    Typical Use Cases

    Business logic in Canvas apps without traditional development

    Calculated fields in Dataverse tables

    Workflow conditions in Power Automate

    Form validation in Power Pages

    Business Benefits

    Shorter time-to-change for form and logic adjustments

    Relieves IT — the business builds it themselves

    The same skill transfers across every Power Platform product

    A lower barrier to entry than JavaScript/TypeScript

    Works Seamlessly With

    Microsoft Power Fx integrates seamlessly with these Microsoft technologies:

    Where we deliver Power Fx

    Service offerings where Power Fx is a primary component.

    Power Fx consult

    Canvas logic getting tangled, formulas copy-pasted, no tests? 30 minutes on your code hygiene — we'll show where YAML source, named formulas and reusable components pay off.

    We use cookies and external services (e.g. Google Maps) to provide you with the best experience on our website. For more information, see our Privacy Policy.