Answered

If Statement not producing expected results

(0) Share

Report

Posted on by hcharris

I have a simple powerapp. The first screen the user chooses one of two options and the result is put in global variable named varoption and transferred to a second screen. On the second screen, the Visible property is set on two data table controls based on the global variable with the following code:

UpdateContext(locdt1Visible:false);

UpdateContext(locdt2Visible:false);

If (varoption = "test1", UpdateContext({locdt1Visible:true});

If (varoption = "test2", UpdateContext({locdt2Visible:true})

The first two lines are there to make sure Visible is set before the selection. locdt1 and 2 are local variables and hare in the Visible of each respective control.

I have tried to code this as a Select statement but that did not help.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

BrianS 2,407 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Can't you just use the global variable everywhere you need it? In the one Gallery's Visible property just put

varoption = "test1"

and in the other

varoption = "test2"

They will evaluate as true or false and the Gallery will show or not. Since the variable is set before the page becomes visible yo should not need to worry that it will show

Was this reply helpful? Yes No
hcharris 30 on at

Like
a
(0)

Report
Copy link

Link copied!

I put the following statement in the Visible property of each of the controls:

If (varOption = "test1", true, false)

a similar statement was added for the second control. Everything in OnVisible for the screen was removed.

I'm so new to this I'm not even sure I'm testing correctly. Right now I save after making changes and then run it. Both controls begin with Visible = false. But when I test. neither control is showing.

I know what is being passed in the var because it is displayed in a message at the top of the screen.

I'll keep trying to figure it out.

Was this reply helpful? Yes No
Verified answer

BrianS 2,407 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Good idea to put the value of the variable on the screens for testing!

You do not really need the If statement in the Visible property, it is looking for a Boolean, so anything that evaluates to true or false will do, so all you really need is

varOption = "test1"

and it will work.

If you highlight that statement does it show the correct answer? For testing can you copy the control for varOption to the second page? It should change the visibility on the fly. If you only have the 2 states yo could also change that variable to Boolean and then just list the variable in the Visible property of the Galleries - one would just have the variable the other would be

!varOption

Was this reply helpful? Yes No
hcharris 30 on at

Like
a
(0)

Report
Copy link

Link copied!

That worked like a champ. You have shown kindness to an old coder who gave it up when C++ came out. I actually met Grace Hopper.

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

Like
a
(0)

Report
Copy link

Link copied!

Us old guys have to stick together - I pretty much gave up database work after Foxpro died an ugly death!

Got sucked back in with this product

Was this reply helpful? Yes No