Set Variable

(0) Share

Report

Posted on by Quincy_Chan

Dear All,

I have some selected questions and would like to set variables for them, for example, "VarDisQuestions".

So when the Question Number is not one of them, then the other field "Question" will be Visible.

This works fine when the question number is one of them (for example, when question number is 16, "Question" is visible;

but when the question number is 2, "Question" is still visible. Would you please help? thank you.

This is my code:

Set Variable Main Screen, OnVisible

Set(VarDisQuestion,(QuestionNumberLabel.Selected.'Question Number' = 1 ||

QuestionNumberLabel.Selected.'Question Number' = 2 ||

QuestionNumberLabel.Selected.'Question Number' = 3 ||

QuestionNumberLabel.Selected.'Question Number' = 4 ||

QuestionNumberLabel.Selected.'Question Number' = 5 ||

QuestionNumberLabel.Selected.'Question Number' = 6 ||

QuestionNumberLabel.Selected.'Question Number' = 10 ||

QuestionNumberLabel.Selected.'Question Number' = 11 ||

QuestionNumberLabel.Selected.'Question Number' = 13 ||

QuestionNumberLabel.Selected.'Question Number' = 14 ||

QuestionNumberLabel.Selected.'Question Number' = 15 ||

)

Question, Visible

If(

!VarDisQuestion,

true,

false

)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

ypatil2 on at

Like (0)

Report
Copy link

Link copied!

@Quincy_Chan What is QuestionNumberLabel.Selected.'Question Number', is it dropdown. If yes then where you are using it.

Was this reply helpful? Yes No
Verified answer

Uismayil 55 on at

Like (1)

Report
Copy link

Link copied!

Hi @Quincy_Chan

You may try below code:

Set(
VarDisQuestion,
Not(
QuestionNumberLabel.Selected.'Question Number' = 1 ||
QuestionNumberLabel.Selected.'Question Number' = 2 ||
QuestionNumberLabel.Selected.'Question Number' = 3 ||
QuestionNumberLabel.Selected.'Question Number' = 4 ||
QuestionNumberLabel.Selected.'Question Number' = 5 ||
QuestionNumberLabel.Selected.'Question Number' = 6 ||
QuestionNumberLabel.Selected.'Question Number' = 10 ||
QuestionNumberLabel.Selected.'Question Number' = 11 ||
QuestionNumberLabel.Selected.'Question Number' = 13 ||
QuestionNumberLabel.Selected.'Question Number' = 14 ||
QuestionNumberLabel.Selected.'Question Number' = 15
)
)

the Set function sets VarDisQuestion to true if the selected question number is NOT one of the specified numbers (1, 2, 3, ..., 15).

to make the "Question" field visible only if VarDisQuestion is true, you may apply below code, which makes it visible when the selected question number is not one of the specified numbers.

Question.Visible = VarDisQuestion

PS: PowerApps variable scope is recommended to as less as possible, so try to use local variable(update context) or onetime variable (with function)

If my response has helped resolve your issue, please consider clicking "Accept as Solution" and giving it a thumbs up so others can find it helpful. ….UIsmayil

Was this reply helpful? Yes No
Quincy_Chan 27 on at

Like (1)

Report
Copy link

Link copied!

Hi Uismayil, thanks a lot for your reply. The variable seems created successfully. However, it is not working in making the Question Visible. I don't think this is due to the selection of question number, because I can make it visible when I do it like this:
Question.Visible=
If(
"Softlines" in ProductLineCombo.SelectedItems.Value &&
Not(QuestionNumberLabel.Selected.'Question Number' = 1 ||
QuestionNumberLabel.Selected.'Question Number' = 2 ||
QuestionNumberLabel.Selected.'Question Number' = 3 ||
QuestionNumberLabel.Selected.'Question Number' = 4 ||
QuestionNumberLabel.Selected.'Question Number' = 5 ||
QuestionNumberLabel.Selected.'Question Number' = 6 ||
QuestionNumberLabel.Selected.'Question Number' = 10 ||
QuestionNumberLabel.Selected.'Question Number' = 11 ||
QuestionNumberLabel.Selected.'Question Number' = 13 ||
QuestionNumberLabel.Selected.'Question Number' = 14 ||
QuestionNumberLabel.Selected.'Question Number' = 15 ||
,
true,
false
)

I know this is really stupid to list out all the numbers, because this is not the only field I want to make it visible in this situation. 😞 Hopefully you can help me.

Update:
I added a column "Visible" to the Question Database and when the specific question should be visible, then the value of Visible will be "Y".
Not sure is it the best way to do so, but works fine and clear now. Thanks a lot for all of your help!

Question.Visible = If("Softlines" in ProductLineCombo.SelectedItems.Value And
VisibleDropdown.Selected.Visible="Y"
,true,false)

Was this reply helpful? Yes No