Unanswered

Multiple Conditional statements to change color for Thisitem.value

(0) Share

Report

Posted on by DanMuriel

Hi Everyone,

I have been trying to add conditional statements to a field in gallery mood to faciliate the view to understand a process that is still pending. I followed the steps from a previous questions. Re: Multiple conditional statements to change color of text based on another columns value not worki

However, when I tried type it out under ThisItem field I get various errors.

This is the formula i used in the field for text:

If(ThisItem.'Email to Stat Sent?'.Value="No", RedThisItem.'Email to Stat Sent?'.Value="Yes", Green )

Can someone help me out....

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Community Power Pla... on at

Like (1)

Report

Hi @DanMuriel ,

I tried this for multi conditional statements in the Color property or certain items displayed for the Gallery and this appeared to work okay, the code depends on the underlying field.

If this is a plain text field I used the following:
If(ThisItem.'Email to Stat Sent?'="Yes",Red,ThisItem.'Email to Stat Sent?'="No",Green)

If you want to display Yellow for entries that do not have Yes or No, then
If(ThisItem.'Email to Stat Sent?'="Yes",Red,ThisItem.'Email to Stat Sent?'="No",Green,Yellow)

However, if the underlying field was a checkbox, this was changed to
If(ThisItem.'Email to Stat Sent?'.Value="Yes",Red,ThisItem.'Email to Stat Sent?'.Value="No",Green)

Or the following to change to Yellow if Yes or No is not entered.
If(ThisItem.'Email to Stat Sent 2?'.Value="Yes",Red,ThisItem.'Email to Stat Sent 2?'.Value="No",Green,Yellow)

Hope this helps

Was this reply helpful? Yes No
RusselThomas 4,014 on at

Like (2)

Report
@DanMuriel,

Aside from the mental flinching seeing question marks in control names (yikes ), the formula you pasted does have one syntactical error;

If(ThisItem.'Email to Stat Sent?'.Value="No", RedThisItem.'Email to Stat Sent?'.Value="Yes", Green )
you would be missing a comma between Red and ThisItem

If( ThisItem.'Email to Stat Sent?'.Value="No", Red, ThisItem.'Email to Stat Sent?'.Value="Yes", Green )
If it's just a typo in your post, then it might be something else.

Kind regards,

RT

Was this reply helpful? Yes No
DanMuriel 30 on at

Like (0)

Report

@RusselThomasYes the coma was missing but that was not the error. The error message that I have always get is

The property expects Text values, but this rule produces incompatible Color values.

This is what is in the text field:

If(
ThisItem.'Email to Stat Sent?'.Value="No", Red,
ThisItem.'Email to Stat Sent?'.Value="Yes", Green
)

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report

@DanMuriel

You need to put these formulas suggested on the Color property, not on the Text property.

Assuming that you wanted to change the text color in all of this. If it's the background you are trying to change, then, for an individual control, put these formulas in the Fill property. If it's an entire Gallery row you're trying to fill, then set the TemplateFill property of the Gallery to the formulas given.

Hope that helps.

Was this reply helpful? Yes No