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
Solved! Go to Solution.
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
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
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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
199 | |
52 | |
41 | |
39 | |
35 |
User | Count |
---|---|
263 | |
86 | |
71 | |
69 | |
66 |