Hello
As a newbie trying to learn PowerApps I am at a crossroads.
I have a form/screen that has 3 questions that you select yes or no using radio buttons.
As well on this form I have a label that displays your progress as "Question 1/40".
Question 1 is visible on start and as you answer or select the next question appears on the form.
My goal is to make the label show "Question 2/40" when Question1 is completed and 2 appears. I have no issues doing this until I get to Question3. I can't figure out how to compound a formula to use the two selected.value if statement. Every time I try I get a blank.
I had the following TEXT = IF(Question1.Selected.Value=True,"Question 2/40","Question 1/40")||IF(Question2.Selected.Value=True,"Question 2/40","Question 3/40")
Help!!!
Hello OdinDelToro
I thank You very much for your assistance - I found the solution based of your code late yesterday.
I needed to use the Blank() instead of true and just needed to remove the & parameter.
Works perfect!!!!
Hello @Mike5025,
Not sure how your form is built. Nonetheless, you can follow an approach to make it visible depending on previous answers.
You have a form with 3 questions, on each label of the data card include in the text "Question 1/40" "Question 2/40" and "Question 3/40" respectively.
After that you'll be able to visualize the title of each card with the name that you're expecting to display.
Now, depending on the answers that you included on the choice column for each question or if you're including text, you'll need to use that on the visible property. In this example, I included as possible answers for each questions the following:
Now, what you want to achieve is to display the questions sequentially after there is an answer from previous question. To achieve that, you need to select the next question data card and in the Visible property you need to include a formula that makes visible (true) in case it's selected any of the possible answers from previous question. If you have 3 answers, include the three answers pointing to the selected.value of the datacardvalue as follows:
After that, if you don't have anything selected it will just display first question
Once you select any answer from Q1, you'll be able to visualize second question
Now, apply same logic to question 3.
After that, if you don't have any answer selected in question 2, next question won't be displayed until you select an answer from Q2.
Once you select answer on Q2, Q3 will be displayed.
Hope this helps clarify the doubt, let me know in case you're still facing an issue within it.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Sorry here is the screen shot
Oops!!!!! This solved the error problem but nothing shows as it should - the label is always blank
Hello @Mike5025,
Power Fx is case-sensitive. Please try the following:
TEXT =
If(
Question1.Selected.Value = false,
"Question 1/40",
If(
Question1.Selected.Value = true,
"Question 2/40",
If(
Question1.Selected.Value = true & Question2.Selected.Value = true,
"Question 3/40"
)
)
)
Hope this helps clarify the doubt, let me know in case you're still facing an issue within it.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Giving me error in formula
Hello @Mike5025,
Try to include all possible combinations within the IF statements. You can try the following approach:
TEXT =
IF (
Question1.Selected.Value = FALSE,
"Question 1/40",
IF (
Question1.Selected.Value = TRUE,
"Question 2/40",
IF (
Question1.Selected.Value = TRUE & Question2.Selected.Value = TRUE,
"Question 3/40"
)
)
)
Hope this helps clarify the doubt, let me know in case you're still facing an issue within it.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
WarrenBelz
89
Most Valuable Professional
MS.Ragavendar
60
stampcoin
48