web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps TemplateFill

Power Apps

Answered

TemplateFill

(0) Share

Report

Report

Posted on by neill_long

708

Hello,

I am looking to add conditional formatting to my gallery. I have the following formula on the TemplateFill of the gallery:

If(DateAdd(ThisItem.EV_Date, -1) = Today(), Red,
ThisItem.Students_Added_Check.Value = "Yes", Green)

Just now, if ThisItem.EV_Date minus 1 is equal to Todays date, then that record is highlighted Red.

However, If ThisItem.Students_Added_Check.Value equals Yes, then the record should highlight Green.

If none of the criteria is meet, then the record should not be highlighted.

It doesn't go green even though it is marked "Yes".

Any suggestions on how i can fix this please?

thanks

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

neill_long 708 on at

Like (0)

Report
I think i have figured this out, I have changed the formula to:

If( DateAdd( ThisItem.EV_Date, -1 ) = Today() && ThisItem.Students_Added_Check.Value = "No", Red, DateAdd( ThisItem.EV_Date, -1 ) = Today() && ThisItem.Students_Added_Check.Value = "Yes", Green, DateAdd( ThisItem.EV_Date, -1 ) < Today() && ThisItem.Students_Added_Check.Value = "No", White )

Seems to be working fine

Was this reply helpful? Yes No
v-yujincui-msft on at

Like (0)

Report

Hi @neill_long ,

Congratulations!!!

Glad to see you figured it out.
Maybe you could consider marking your answer as a 'Solution' to close the case.

Best Regards,
Charlie Choi

Was this reply helpful? Yes No

Join the conversation