Skip to main content

Notifications

Power Automate - General Discussion
Answered

formula/expression beautifier indenting

(0) ShareShare
ReportReport
Posted on by 71

Anyone found an online tool for beautifying messy formula expressions? You know, with proper indenting to make it more readable?  I'm aware of the helpful indenting in the editor when you type an expression- each time you press enter, it indents properly.  But I'm often typing in another editor, or copying/pasting, or too lazy to use the editor properly.  

 

I want to turn this:

SJacobs_1-1631388280000.png

 

Into this:

SJacobs_0-1631388189292.png

 

 

  • SJacobs Profile Picture
    SJacobs 71 on at
    Re: formula/expression beautifier indenting

    Thanks ekarim2020 - that's just what I was looking for.  I tried nearly every programming language I could think of, but not came out as well formatted as that one.  

    PREVIEW
     
     
     
  • Verified answer
    Ellis Karim Profile Picture
    Ellis Karim 10,572 on at
    Re: formula/expression beautifier indenting

    As the Power Fx language used in Power Apps and Power Automate is based on Microsoft Excel, all I can suggest is that you try the Excel Formula Beautifier site Online Excel Formula Beautifier:

     

     

    if(or(empty(triggerOutputs()?['body/LatLong']), equals(triggerOutputs()?['body/LatLong'], ',')),'25.35342762,55.43085479',triggerOutputs()?['body/LatLong'])

     

     

    ekarim2020_2-1631394459765.png

    Just remove the equals sign from the Beautifier then paste into Power Automate.


    Ellis
    ____________________________________
    If I have answered your question, please mark the post as Solved.
    If you like my response, please give it a Thumbs Up.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard