Multiple Conditions

(0) Share

Report

Posted on by Veronika_Kys123

Hello,

Might be a silly question, but my goal here is to fill a dot based on what choice is in datacard.

Idea is : orange = if pending, green = if approved, red = if declined.

Somehow I cant make it work.

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (2)

Verified answer

iAm_ManCat 18,228 Most Valuable Professional on at

Like (1)

Report
Heya, I think you just have an extra comma at the end of your formula after the last White, remove that comma and it should work 🙂

Actually, I think you can remove all of those White values except the last one, like this:

If( DataCardValue49.Selected.Value = "Pending", Orange, DataCardValue49.Selected.Value = "Approved", Green, DataCardValue49.Selected.Value = "Declined", Red, White )

Was this reply helpful? Yes No
jorge.daniel 1,430 Super User 2024 Season 1 on at

Like (0)

Report

Hi,

Try this:
If(
DataCardValue49.Selected.Value = "Pending", Orange,
If(
DataCardValue49.Selected.Value = "Approved", Green,
Red
)
)

Was this reply helpful? Yes No
Verified answer

Mink21 158 on at

Like (1)

Report

As @iAm_ManCat said, you have an extra comma threre at the end.

You could also use a Switch in this case:
Switch(DataCardValue49.Selected.Value, "Pending", Orange, "Approved", Green,"Declined",Red,White)

Was this reply helpful? Yes No
jorge.daniel 1,430 Super User 2024 Season 1 on at

Like (1)

Report

Hi @iAm_ManCat ,

Are you confident in using this "simplified" if statement? I still use nested IFs.

Was this reply helpful? Yes No
iAm_ManCat 18,228 Most Valuable Professional on at

Like (1)

Report
Yes absolutely - this isn't a simplified statement, its how If's are meant to be used:

If( logic1, answer1, //else if logic2, answer2, //else if logic3, answer3, //else answer4 )

The nested if is actually less performant and can lead to performance impacts in larger nested ifs.

Was this reply helpful? Yes No
jorge.daniel 1,430 Super User 2024 Season 1 on at

Like (1)

Report

This is why love the community, learning opportunities are just around the corner. Thanks @iAm_ManCat

Was this reply helpful? Yes No
iAm_ManCat 18,228 Most Valuable Professional on at

Like (0)

Report

Totally agree and glad to help!

#SharingIsCaring

Was this reply helpful? Yes No
Veronika_Kys123 68 on at

Like (0)

Report

Hello all,

Sorry I had a day off on Friday. Unfortunately non of these are working. 😞 Using IF or SWITCH the color is returning white even when selected...

Was this reply helpful? Yes No
Veronika_Kys123 68 on at

Like (0)

Report

Ah.. never mind! Added new Valuecard with 3rd approval and the two previous dots started working.. 😄

So both IF and Switch are working! Thank you so much! You saved me! 🙂

Was this reply helpful? Yes No