Glossary

Power Fx

The Excel-like formula language used across Power Apps, Power Automate, and other Power Platform tools.

Power Fx is the low-code formula language used across the Power Platform — primarily in Power Apps canvas apps, with growing use in Power Automate, Dataverse formula columns, and Copilot Studio. Modelled on Microsoft Excel formula syntax: declarative, strongly-typed, designed for non-developers. Common patterns: Filter(Customers, Status = "Active"), Patch(Orders, Defaults(Orders), {Customer: ThisItem.ID}), If(IsBlank(field), "Required", ""). Open-sourced by Microsoft in 2021, with the spec and reference implementation on GitHub. The closest the Power Platform comes to a unifying "language" — knowing Power Fx makes most Power Platform tools approachable.