Answered

Label Visibility

(0) Share

Report

Posted on by Gingerclaire_

I am new to PowerApps and I'm trying to change a labels visibility using an If statement. If the value in one field is greater than the value in a second but I keep getting the error "This data type is unsupported for evaluation".

My If statement: If(ForceCalculation.value > BreakingStrength.value, false, true).

Can anyone help a newbie or point me in the direction?

Categories:

Building Power Apps

All responses (7)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Gingerclaire_

Can you please share more of what your ForceCalculation and BreakingStrength are.

Are they variables, controls, fields?

Are you trying to change a label in a Gallery or just on a screen?
Gingerclaire_ 8 on at

Like
a
(0)

Report
Copy link

Link copied!

They are text input fields, one of them had a formula and one is free text, and it’s just on the screen.
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Gingerclaire_

Very good. In that case, your formula for the Visible property should be this:

Value(ForceCalculation.Text) < Value(BreakingStrength.Text)

This will return a true or false, so there is no need to wrap it in a If statement to then again return a true or false.

Also notice that I changed your > to < as that would validate the statement properly for a true or false return.

I hope this is helpful for you.
Gingerclaire_ 8 on at

Like
a
(0)

Report
Copy link

Link copied!

That’s very helpful thanks! I’ve now got it working how I wanted it to but I have another question.

What do I have to add so it will remain hidden if the BreakingStrength field is left blank?
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Gingerclaire_

(Value(ForceCalculation.Text) < Value(BreakingStrength.Text)) && !IsBlank(BreakingStrength.Text)

This will set the Visible property to true if the ForceCalculation is less than the BreakingStrength AND that BreakingStrength is not Blank.

Hope that helps.
Gingerclaire_ 8 on at

Like
a
(0)

Report
Copy link

Link copied!

I want to edit it so the statement is true if the ForceCalculation is greater than the BreakingStrength AND that BreakingStrength is not Blank.

but when I change < to the > symbol it shows the message of the field is blank. Why is it doing that?
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Gingerclaire_

Yes, but your logic might be a bit backward.

Spell it out first - If the Breaking Strength is specified and the Force Calculation is Greater than the Breaking Strength then the label should be visible.

Then add operators - If the Breaking Strength is specified (!IsBlank) and (&&) the Force Calculation is Greater (>) than the Breaking Strength then the label should be visible (true).

Then expand and combine - Visible = (If !IsBlank(Breaking Strength) and (&&) (Value(Force Calculation) (>) Value(Breaking Strength)) true)

Then simplify and add control names - !IsBlank(BreakingStrength.Text) && (Value(ForceCalculation.Text) > Value(BreakingStrength.Text))

Then prove -

Force Calculation Breaking Strength IsBlank Formula Substitute Simplified Result

1 1 false !false(true) && (1 > 1) (false) true && false = false (not visible)

2 1 false !false(true) && (2 > 1) (true) true && true = true (visible)

1 2 false !false(true) && (1 > 2) (false) true && false = false (not visible)

2 true !true(false) && (2 > 0) (true) false && true = false (not visible)

0 true !true(false) && (0>0) (false) false && false = false (not visible)

See if that is in fact what you are looking for.