Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Conditional Formatting HTML Table from Power BI

(0) ShareShare
ReportReport
Posted on by

Hi all, I'm trying to generate a draft email with a table containing data from my Power BI.

 

I have a column called "ISR vs LPA", which I would like to apply conditional formatting for. If the value is between 0.8 and 1.2, the cell should be highlighted green. Otherwise, it should be highlighted red.

 

I tried something like the below but it does not work. Appreciate all help thank you!

 

Conditional Formatting Power Automate.png

 

  • ManishSolanki Profile Picture
    ManishSolanki 15,075 on at
    Re: Conditional Formatting HTML Table from Power BI

    Hi @Anonymous 

     

    Pls try wrapping left side operand that comes from power BI inside float() formula to make it compatible for the comparison. You need to type cast both left side operand coming from Power BI.

    Here is an example of converting string to float used for comparison:

    ManishSolanki_0-1689272203666.png

     

    If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

     

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

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard