Power Fx

Concept

Microsoft's open-source low-code formula language, modelled on Excel formulas, used in Power Apps, Power Automate, Dataverse and Copilot Studio.

Description

Power Fx lets makers express logic with formulas like =Filter(Orders, Status = "Open") instead of code. It is declarative and strongly typed, so formulas recalculate automatically when the data they depend on changes. Because it follows Excel conventions, people who know Excel formulas can build app logic quickly.

The language is open source and also runs outside Power Apps, for example in Dataverse formula columns and in Copilot Studio.

Sessions on this topic (2)

• AI Powered Development for Power Platform Professionals · Victor Dantas · M365Con 2027
• AI Powered Development for Power Platform Professionals · Victor Dantas · M365Con 2027

Glossary

Related topics in brief

• Power Apps · Related to · Product
  A low-code tool for building custom business apps for web and mobile. Canvas apps give full control over the layout, while model-driven apps are generated from the data model in Dataverse.
• Microsoft Excel · Related to · Product
  Spreadsheet application of Microsoft 365 for calculations, tables, charts and data analysis, with Power Query, PivotTables, dynamic arrays and Copilot.
• Power Platform · Related to · Platform
  Microsoft's low-code family consisting of Power Apps, Power Automate, Power BI, Power Pages and Copilot Studio. Together with Dataverse it lets business users build apps, automations, reports and agents.
• Copilot Studio · Related to · Product
  Microsoft's low-code platform for building, customising and publishing AI agents and copilots. Makers define topics, knowledge sources, actions and flows and can publish the result to Teams, websites or Microsoft 365 Copilot.
• Power Pages · Related to · Product
  Power Pages is a low-code service for building secure, data-driven business websites.
• Dataverse · Related to · Product
  The managed data platform behind Power Platform and Dynamics 365. It stores tables with relationships, security roles and business logic, so apps and agents work on one governed data source.
• Canvas app · Related to · Concept
  Power Apps app type where the maker designs the screen layout freely, like a slide, and connects it to data with Power Fx formulas.
• Victor Dantas · Related to · Person
  Victor Dantas is a speaker at M365Con 2027 (Director of Services at Eyedeas Inc) with 1 session.
• Microsoft Certified: Power Platform Developer Associate (PL-400) · Covered by · Certification
  Associate certification for building extensions and integrations on Power Platform. The exam is moving to AB-400; PL-400 testing ends 30 October 2026.

Experts and companies for this topic

Nobody has listed this topic yet. Add it to your profile.