Answered

Conditional formatting Gallery Color by two value

(0) Share

Report

Posted on by arthurbeaulieu

Hello,

I try to use a If formula who can change color of my Gallery.
It work perfectly when i do that with one value:

If(ThisItem.'Problème ?'=true;Red;If(ThisItem.'Problème ?'=false;Green))

but i want to do something with two value in the same time

If(ThisItem.'Problème ?'=true;Red;If(ThisItem.'Problème ?'=false;Green;If(ThisItem.'Résolu ?'=true&ThisItem.'Problème ?'=true;Blue)))

in more mathematical way i want this

If ValueA = true -> Red
If ValueA = False -> Green
If ValueA = True AND ValueB = true -> Blue

The condition must be ruled by two fonction.

Hope someone can help me, its look eay but i'm stuck at this point. (The app will be finished after that)

Regards
Arthur

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Arne_R 97 on at

Like (0)

Report
Copy link

Link copied!
Hi,
I don't know if this works. But you can try it..

If( valueA = true && valueB = true ; "Blue"; valueA = true && valueB = false ; "Red"; valueA = false && valueB = true ; "Green"; valueA = false && valueB = false ; "/" )

Arne

Was this reply helpful? Yes No
BrianS 2,407 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You should be able to test for the "True" version, then the "And" and then use the "else" part of the original If for the

"False" version:

If(ThisItem.'Problème ?'=true;Red;If(ThisItem.'Résolu ?'=true&ThisItem.'Problème ?'=true;Blue);Green)

the syntax may not be exactly right as my version uses "," whereas yours uses ";", but it should be close

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

Like (0)

Report
Copy link

Link copied!
Your code, formatted for readability (plus my comments):
If(ThisItem.'Problème ?'=true; Red; If(ThisItem.'Problème ?'=false; Green; If(ThisItem.'Résolu ?'=true & ThisItem.'Problème ?'=true ;Blue // can never be reached because ThisItem.'Problème ?' is false // also operator & is the concatenation operator; && is the logical and operator ) ) )

I'm assuming a little bit but this might be what you want:

If(ThisItem.'Problème ?'; // =true is redundant If(ThisItem.'Résolu ?'; Blue; // ValueA && ValueB Red; // I'm guessing you meant that you want red if ValueA && !ValueB ); Green )

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

Like (0)

Report
Copy link

Link copied!

This can't work because in the else part of If(ThisItem.'Problème ?'=true...), ThisItem.'Problème ?' must be false. thus Blue can never be returned and therefore this is logically identical to If(ThisItem.'Problème ?';Red;Green)

Was this reply helpful? Yes No
Verified answer

BrianS 2,407 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

I just tested this and it works:

If(ValueB And ValueA,Blue,!ValueA,Green,Red)

You will need to replace "," with ";"

Was this reply helpful? Yes No
arthurbeaulieu 30 on at

Like (0)

Report
Copy link

Link copied!

Thank you All for your reply, this place is very helpfull for beginner like me ! i try the @BrianS solution and it work perfectly. This elegant single line is what i need. But i want to thank you all for your contribution

Was this reply helpful? Yes No