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
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!
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
@Melissaed26 , so you are looking for format Calculated field value as percentage in flow while creating a HTML table?
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2