Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Calculated columns with Iferror format in power automate

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








Super User
Super User

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

Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.

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

Helper I
Helper I

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!



Helpful resources

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,901)