Answered

Color changing based on content

(0) Share

Report

Posted on by SectorOMEGA

338

I have a simple power app for user registration. Behind it I have a simple power automate to send HTML formatted messages:

PA Covid.PNG

What Im trying to achieve is change the color of the input of 'Employee Last Site Visit' to be based on the 'Date' column.

For example if 'Employee Last Site Visit' is 3 days smaller than 'Date' column, than Input to be in red color.
Is this even possible? Thank you in advance.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

RezaDorrani 12,145 on at

Like (1)

Report
Copy link

Link copied!

Hi @SectorOMEGA

Check https://www.youtube.com/watch?v=VnWg-Eox37Q

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

Was this reply helpful? Yes No
SectorOMEGA 338 on at

Like (0)

Report
Copy link

Link copied!
Hi @RezaDorrani THANK YOU so much for this one. Really useful and nice video. However when I recreate it with the expressions form it I receive this:
2021-10-05
2021-08-01
<font color = "green">Closed</font>
2021-10-05
2021-07-01
<font color = "red">Open</font>
For the color expression Im using this code:
if(equals(item()?['CaseStatus/Value'],'Open'),'red',if(equals(item()?['CaseStatus/Value'],'Closed'),'green','black'))
As per the above return the code works because it changes the status but Im not getting color rather getting the code back with the true/false statement. What Im missing?

Was this reply helpful? Yes No
SectorOMEGA 338 on at

Like (1)

Report
Copy link

Link copied!

@RezaDorrani Fixed. I was missing ' in the clean HTML step. I have added it and all is working good. Thank you so much Reza

Was this reply helpful? Yes No