Unanswered

Display Negative Values Red in HTML Table

(0) Share

Report

Posted on by Community Power Pla...

Hi everyone. I built a flow that pulls data from an excel table and returns the data in an HTML table. I have already formatted the number values to display as a currency with negative values in parenthesis. Is there a way to also format negative values in red?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

VictorIvanidze 13,073 on at

Like (0)

Report

Yes. Use HTML formatting.

Was this reply helpful? Yes No
tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report

Hello @Anonymous ,

you can use the approach described in this article, the only difference in your use case will be the condition - instead of comparing dates you'll have to compare the number against the -3 value.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @tom_riha,

Thanks for the response. The article doesn't specifically apply to what I'm trying to do. Any idea as to what would I add to the below code to make negative value red?

if(empty(item()?['Net']),'$0.00',formatNumber(float(item()?['Net']),'C2'))

Was this reply helpful? Yes No
tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report
Probably something like below:

if(less(item()?['Net'],0)), concat('<span style="color:red">', if(empty(item()?['Net']),'$0.00',formatNumber(float(item()?['Net']),'C2')), '</span>'), if(empty(item()?['Net']),'$0.00',formatNumber(float(item()?['Net']),'C2')) )

+ the replace(...) in the email body

Was this reply helpful? Yes No