Reuse Power Fx formulas with user defined functions


Some of the functionality described in this release plan has not been released. Delivery timelines may change and projected functionality may not be released (see Microsoft policy). Learn more: What's new and planned

Enabled for Public preview Early access General availability
Admins, makers, marketers, or analysts, automatically Jun 2023 - -

Business value

Organize and reuse formulas by encapsulating logic into functions.

Feature details

Power Fx now supports user defined functions. Large formulas can be split into smaller parts, which is easier to understand, test, and reuse across an app. Functions can be recursive and can be imperative with side effects.

Power Fx user defined function and formula.