cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Melissaed26
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

 

Melissaed26_1-1608689964668.png

Melissaed26_2-1608690062348.png

Melissaed26_3-1608690100290.png

 

 

 

3 REPLIES 3
annajhaveri
Super User
Super User

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

Regards,
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

Melissaed26
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!

Melissaed26_0-1609208773140.png

 

Helpful resources

Announcements
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)