Conditional IF() in HTMLtext for Font Color

[Anonymous]

Hi,

I have a scanning app, and at the end, it sends out a HTML to the email. 

The HTML has a table, and I want to make a conditional statement in couple of the columns.

I have Item code, Lot #, and Expiry Date as the column headers.

Whenever, the Expiry Date is equal or less than todays date for that product, that rows Lot # and Expiry Date should be changed to a red font instead of black.  

Currently, I have this: 

<td>"&If(DateValue(Text(Value(EXPIRY),"[$-en-US]20##-##-##"))<=Today(),EXPIRY && Red , EXPIRY && Black )&" </td> 

But gives me the Invalid Argument error, and it makes sense as Red and Black are Color. 

Is there a way to do this? 

* The table headers and rows are connected with Concat function. 

[mdevaney · Accepted solution]

@Anonymous 

I think the issue is you need to change the font color via HTML rather than using the PowerApps language.

<td><font color="""&
If(DateValue(Text(Value(EXPIRY),"[$-en-US]20##-##-##"))<=Today(),"Red", "Black")&"""> EXPIRY </font></td>"

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[Anonymous]

@mdevaney 

You're right. 

I was able to fix it using your framework. 

Thank you