How to change font color in HTML table using two and conditions

Like (0) Share

Report

Posted on 1 Mar 2023 04:28:22 by Brpanda23

My SharePoint list got RoomStatus: Blocked/Released and BlockedUntil: Date.

Under select action, I can change fonts for BlockedUtil with a 3 days date check with the below expression.

If(empty(item()?['BlockedEndDate']), '', if( lessOrEquals(item()?['BlockedEndDate'] , addDays(formatDateTime(utcNow(), 'yyyy-MM-dd'), 3, 'yyyy-MM-dd')), concat('<font color= "Red">',item()?['BlockedEndDate'],'</font>') , concat('<font color= "Green">',item()?['BlockedEndDate'],'</font>')))

But when I want to use it like -If RoomStatus equals Blocked and above condition, I am getting a syntax error. New bee here. Any help?

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-dezhili-msft Microsoft Employee on 01 Mar 2023 at 04:54:30

Like (0)

Report
Re: How to change font color in HTML table using two and conditions

Hi @Brpanda23 ,

Please try:
If(empty(item()?['BlockedEndDate']), '', if( and(equals(item()?['RoomStatus/Value'],'Blocked'),lessOrEquals(item()?['BlockedEndDate'] , addDays(formatDateTime(utcNow(), 'yyyy-MM-dd'), 3, 'yyyy-MM-dd'))), concat('<font color= "Red">',item()?['BlockedEndDate'],'</font>') , concat('<font color= "Green">',item()?['BlockedEndDate'],'</font>')))

Best Regards,
Dezhi

Was this reply helpful? Yes No
Brpanda23 4 on 01 Mar 2023 at 10:04:06

Like (0)

Report

Re: How to change font color in HTML table using two and conditions

Thank you!!

Was this reply helpful? Yes No