Skip to main content

Notifications

Power Automate - General Discussion
Answered

Dynamic HTML Table Data error

(0) ShareShare
ReportReport
Posted on by

Through flow i have dynamic HTML table.  got total expenses and budget from dynamic HTML table. 

i tried to calculate  sum and percentage from below formula but I got error in dividing..
It shows below error.

 
 

1.JPG2.JPG

 

mul(div(float(variables('TodateExpenses')),float(variables('Budget'))),100)
 
It's seems it is trying to divide empty body field. Is there way out?
 
Any tips?
  • sgr Profile Picture
    sgr on at
    Re: Dynamic HTML Table Data error

    you are correct, some time solution is so simple but we overlooked. thank you for your suggestion. 

  • Verified answer
    abm abm Profile Picture
    abm abm 32,296 on at
    Re: Dynamic HTML Table Data error

    Hi @sgr 

     

    Add an If condition to check variables('Budget') is null or use an expression to check the length > 0 of variables('Budget').

     

    Thanks

     

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard