Power Apps Formula Beautifier

v1.0

Paste a Power Fx formula and get clean, readable code for Power Apps, blog posts and documentation.

All Tools

Free & 100% Ad-Free · No Cookies · No Data Stored

Load sample formula

Choose a sample

More options

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.

0 levels deep 0 function calls

Raw formula

Paste or type your formula

Input stays in this browser 0 lines · 0 characters

Formatted output

Live preview

PNG image Tip: add ALT text to the image when you post it.

Rainbow brackets show nesting 0 lines · 0 characters

Local syntax checks

Brackets, quotes, separators, operators and the casing of common functions. Names, data types and delegation are checked only in Power Apps Studio.

Enter a formula to run local syntax checks.

What's in this formula

Functions, variables and collections found in the formula. Select a function to open it in the Power Apps Formula Explorer.

Enter a formula to see its building blocks.

Built for Power Apps makers

About the Tool

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.

Quick answers

Frequently Asked Questions

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.