PowerApps Formula Reference Guide Navigating the New vs. Old Formula Editor

PowerApps Formula Reference Guide: Navigating the New vs. Old Formula Editor


PowerApps Formula Reference: Understanding the New Formula Editor

In this PowerApps Formula Editor Comparison, we delve into the nuances of the new and old formula editors in Power Apps Studio. The introduction of the updated formula bar has brought significant changes to how users interact with formulas. This guide will help you understand these changes, highlighting the features and functionalities of both editors to make your PowerApps development experience smoother.

A Glimpse into Power Apps Studio’s New Formula Editor

Power Apps Studio proudly presents its newly integrated formula editor, deriving its foundation from the esteemed Monaco code editor. For those who are familiar with Visual Studio Code, the transition will be smooth as the underlying behavior mirrors the Monaco editor.

Note: Currently, this editor is in its preview phase. To leverage its features, one must activate it from the app settings.

Why Opt for the New Formula Editor?

Once you commence with the new formula bar, you’ll instantly recognize its swiftness. The typing experience becomes more fluid, ensuring minimal lag, thus making the editing process feel brisk.

A standout feature of this editor is its extended help section and enriched IntelliSense. For instance, if you input the command ‘Patch‘, the bar will furnish a comprehensive description of the formula, aiding the user’s understanding. In addition, its intuitive design, represented by the up and down arrows, provides further insights into formula usage.

The older formula bar, in contrast, came with an IntelliSense that was considerably more limited in its offerings. Furthermore, this enhancement now extends to the properties pane. Unlike its predecessor, where controls in this pane were devoid of assistance, the new formula bar promises consistent help.

Reasons to Stick with the Old Editor

While the new editor has its merits, there are some features from the old one that users might miss. A prominent feature is the formula reference dropdown panel. Earlier, users could easily access a list of functions grouped by categories via the ‘fx‘ dropdown.

Additionally, the older editor provided an in-bar ‘find and replace‘ utility, which is notably absent in the newer version. However, this shouldn’t pose a significant concern as one can still execute a global ‘find and replace‘ from the menu in the left panel.


To encapsulate, the latest formula editor in Power Apps Studio stands out as a significant enhancement over its predecessor. It’s worth integrating it into your workflow, courtesy of its swift performance and an upgraded IntelliSense. Despite the absence of some features, they weren’t commonly utilized, and there’s hope that Microsoft will reincorporate them in upcoming versions.

If you need further clarity or assistance on the PowerApps formula reference or any other tech-related queries, don’t hesitate to contact us. Our team is here to assist and guide you, ensuring your technical endeavors are always on the right track.

About The Author