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

(0) Share

Report

Posted on 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?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-dezhili-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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 at

Like (0)

Report
Copy link

Link copied!

Thank you!!

Was this reply helpful? Yes No