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
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,946)