web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : nm3CsvxD8h48qIP0JlVLXT
Power Automate - Building Flows
Unanswered

Calculated columns with Iferror format in power automate

Like (0) ShareShare
ReportReport
Posted on 23 Dec 2020 02:22:14 by 42

Please help

 

I have SharePoint list that has a calculated column that divides two other columns to get percentage. The column is set as number but shows as percentage. It has iferror as part of calculation to return 0 if dividing by blank.

 

I am creating a flow with an html table that I am formatting to enhance appearance and to have this column return a percentage instead of decimals. I have gotten everything to work but this column formatting. The flow will work without it. 

 

I have tried adding variable, compose, int, float, number format and all have given me errors or returned 0 value (when I set it with if function to do so if no number found). I am sure this is either due to me doing something wrong or the iferror part of calculation.

 

I am self taught in both power automate and SharePoint lists so my knowledge is limited. I have been researching for the past 6 hours without finding a solution. Please  help

 

Melissaed26_1-1608689964668.png

Melissaed26_2-1608690062348.png

Melissaed26_3-1608690100290.png

 

 

 

  • Melissaed26 Profile Picture
    42 on 29 Dec 2020 at 02:28:08
    Re: Calculated columns with Iferror format in power automate

    I been trying more things I find on the internet, it looks like it is seeing the calculated column results as null. I used an expression to return 0 if null and below is the result. This is with the same data that shows decimal numbers above.

    I completely do not understand how the calculated column can have number but be seen as null.

     

    Please help!

    Melissaed26_0-1609208773140.png

     

  • Melissaed26 Profile Picture
    42 on 29 Dec 2020 at 00:37:09
    Re: Calculated columns with Iferror format in power automate

    I am looking to format the calculated column and then add it to an html table or format it in the table which ever is possible and doesn't require me to completely redo the flow is preferable. 

     

    Thanks for replying

  • annajhaveri Profile Picture
    8,531 Most Valuable Professional on 23 Dec 2020 at 11:39:37
    Re: Calculated columns with Iferror format in power automate

    @Melissaed26 , so you are looking for format Calculated field value as percentage in flow while creating a HTML table?

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

Announcing our 2025 Season 2 Super Users!

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete