Flows Made Easy

Power Apps Formula Beautifier

What's New

Turn long Power Fx formulas into clean, readable code

More tools

Load sample

Choose a sample

Commas or semicolons?

Power Apps changes the punctuation in formulas to match your language. In English, commas separate the parts of a formula. In many European languages, such as French, German and Spanish, semicolons are used instead, and decimals use a comma.

Most people can leave these settings as they are.

How is your formula written?

Show the formatted result with

Useful when sharing a formula with people who use a different language.

Raw formula

Paste or type your formula

Data never leaves your browser 0 lines0 chars0 deep0 functions

Formatted output

Live preview

PNG style

Rainbow brackets show nesting 0 lines · 0 characters

Syntax check

Checks brackets, quotes, separators, operators and function casing. Names, data types and delegation are checked in Power Apps Studio.

Paste a formula above to check it.

What's in this formula

Select a function to open it in the Power Apps Formula Explorer.

Paste a formula above to see what it uses.

About

About the tool

Built for Power Apps makers.

The Power Apps Formula Beautifier is a free Power Fx formatter. It turns long, single-line Power Apps formulas into clean, indented code, and it understands Power Fx: double-quoted text, single-quoted names such as 'Due Date', records and tables, string interpolation, comments, chained behaviour formulas, named formulas and both comma and semicolon separators. Use it to read a formula someone else wrote, track down a missing bracket, or share tidy, highlighted code in documentation and blog posts with Copy in colour or Save PNG.

FAQ

Frequently asked questions

Formatting, separators, sharing and privacy.

What does the Power Apps Formula Beautifier do?
It formats Power Fx formulas from Power Apps into clean, indented code. Nested functions such as If, Switch, Filter and Patch, records, tables, long conditions and chained behaviour formulas are laid out so the logic is easy to follow.
How do I format a Power Fx formula?
Copy the formula from the Power Apps formula bar and paste it into the Raw formula box. The formatted version appears straight away. Choose a format and width, then select Copy code to paste it back into Power Apps.
Which format should I choose?
Smart keeps short parts such as Text(Now(), "dd mmm") on one line and only breaks what goes past the width. Expanded puts every argument of a function on its own line. One line puts the whole formula on a single line.
Can I paste the formatted formula back into Power Apps?
Yes. The beautifier only changes spaces and line breaks, so the formula works the same way in the formula bar. In the One line format, // comments become /* */ comments so they don't hide the rest of the formula.
How do I share a formula in a blog post or document?
Select Copy in colour to paste highlighted code into Word, Outlook, OneNote or Teams, or Save PNG to download an image with a title such as Gallery1.Items. Add ALT text to the image when you post it.
Does it support semicolon separators used in European languages?
Yes. It detects whether a formula uses commas or semicolons between arguments. Under More options you can convert a formula from one style to the other, including decimal numbers and the chaining operator (; or ;;).
Is my formula sent anywhere?
No. Formatting, checks and image export all run in your browser. Your formula is not uploaded or stored.