0

Trying to fill a rectangle shape in a gallery based on a selection.

Using formula below, but not working:

If(ThisItem.'Risk Status'.Value="OPEN",RGBA(235, 130, 125, 1), Or(ThisItem.'Risk Status'.Value="CLOSED", RGBA(115, 205, 170, 1), Or(ThisItem.'Risk Status'.Value="VALIDATED",  RGBA(255, 153, 51, 1))

Could anyone help? Thanks a million!

1 Answer 1

1

Try using below formula:

If(ThisItem.'Risk Status'.Value = "OPEN", RGBA(235, 130, 125, 1), ThisItem.'Risk Status'.Value = "CLOSED", RGBA(115, 205, 170, 1), ThisItem.'Risk Status'.Value = "VALIDATED", RGBA(255, 153, 51, 1), RGBA(255, 255, 255, 1))

I have added default color as RGBA(255, 255, 255, 1) at the end of the formula. You can change it as per your requirements or skip it.

Documentations:

  1. If and Switch functions in Power Apps
1
  • 1
    Thanks a million ganesh! it worked nicely
    – Jose1978
    Feb 11, 2022 at 10:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.