Highlight Gallery row with specific color based on Condition

(0) Share

Report

Posted on by lardo5150 Microsoft Employee

I have a gallery, i want to highlight a row based on a condition.

According to this site, I should use the TemplateFill field.

i am doing that, but not getting the condition to catch.

There is Queue Status, and then another field called cases, that is determiend by adding fields from a SPO List.

So the queu status looks like

ThisItem.EngineerQueueStatus.Value

And the cases:

ThisItem.'Crits Assigned' + ThisItem.'Non-Crits Assigned' + ThisItem.'POCs Assigned' + ThisItem.'SIEs Assigned'

I need to combine these two. So an If one is available and the other is zero, highlight the row.

here is what I am trying to use, but keep either getting an error or nothing happens.

Gallery TemplateFill

f(ThisItem.EngineerQueueStatus.Value = "Available" & (ThisItem.'Crits Assigned' + ThisItem.'Non-Crits Assigned' + ThisItem.'POCs Assigned' + ThisItem.'SIEs Assigned' = 0),Color.Yellow,Color.Transparent)

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

JayMagness 1,663 on at

Like
a
(0)

Report
Copy link

Link copied!

HI,

Not sure if you did not copy it but an "I" is needed to start.
Also, you are missing either the true or the fault action. there is only the If test, and only the true action or the false action not shure what one. there should be two "," in the if statement. One after the test, and one after the action to take if true, then the action if false at the end with a )

Was this reply helpful? Yes No
lardo5150 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I have that, I have the IF, then if true, it is yellow, if not transparent.

Was this reply helpful? Yes No
lardo5150 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Another thing to mention, even when I get the formula where there is no errors, nothing changes.
For example:
If(ThisItem.EngineerQueueStatus.Value = "Available",Color.Yellow,Color.Black)
The value is Available, but nothing changes.

Was this reply helpful? Yes No
lardo5150 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Here is my Gallery.
What I want is to highlight each row that the person is Available and Cases is 0.
The field that has Available in it is the text input
Cases is a sum of different fields in SPO

My ultimate goal is to do an If.
If queue status is Available AND cases is zero, then highlight the row.

I am having issues combining the two conditions, but the first issue I am running into is just highlighting the row.
I broke it down to just one condition, and can't get it to highlight.
My latest attemp is a simplified version.

If( QueueStatus.Text = "Available", Color.Yellow, Color.Black)

Obviouisly there are matches, but the row never highlights.

Same here, I know this matches, but no colo changes:
If( ThisItem.EngineerQueueStatus.Value = "Available", Color.Yellow, Color.Black)

Was this reply helpful? Yes No
lardo5150 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Ok, I found out why it is not working.
The previous author put in a background that alternates rows of white and White smoke, to make it easier to read.
Example( you can see the alternating)

The FILL on that backround is this:

If(Mod(Value(ThisItem.RowNumber),2)=0, Color!WhiteSmoke, Color!White)

How could I modify this so that it is an and, maybe an or?
Would like to add that if it is Available and zero cases, it is yellow.

If I try to add another If statement, I get an error at the end of the first line:

f(Mod(Value(ThisItem.RowNumber),2)=0, Color!WhiteSmoke, Color!White); If(ThisItem.EngineerQueueStatus.Value="Available" && Sum(ThisItem.'Crits Assigned',ThisItem.'Non-Crits Assigned',ThisItem.'POCs Assigned',ThisItem.'SIEs Assigned') = 0,Color.Yellow)

Was this reply helpful? Yes No
lardo5150 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
this might be my solution.
It is still alternating rows, and marking the correct ones with the color I want.
Will check again tomorrow:

f(ThisItem.EngineerQueueStatus.Value="Out of Queue" && Sum(ThisItem.'Crits Assigned',ThisItem.'Non-Crits Assigned',ThisItem.'POCs Assigned',ThisItem.'SIEs Assigned') = 0,ColorFade(Color.Red,0.5), If(Mod(Value(ThisItem.RowNumber),2)=0,Color!WhiteSmoke, If(Mod(Value(ThisItem.RowNumber),1)=0,Color!White)))

Was this reply helpful? Yes No