add skip logic on gallery form

[ed120800]

I create a dynamic form with Gallery base on Reza' tutorial below and now I would like to add a skip question base on the response on questions.

e.g.

Question 1 with Option A and Option B

If Answer is 

Option A -> Go to Question 2 

Option B -> Go to Question 3

https://youtu.be/wQqetH2QLyk?si=m_3CDMfC79p1iVkU

Is it possible?

[ed120800]

Hello @EddieE 

I face another issue when I test the app.

The app success to hide the Question 2 when I select "I have consented" in Question 1. 

However, it didn't unhide Question 2 when I change back to select "I do not consent". 

Any idea? 

[EddieE]

@ed120800 

Without exact code & data I cannot say for sure what is happening. When I use the code I offered with the data in my dummy SharePoint List the second question (ie Question2) shows/hides as needed, without issue.

Check that the data is setup correct, ie that the dropdown data is ALL the same eg

"I have consented;I do not consent"

Check there aren't any extra spaces, spelling mistakes, Upper / Lower case is all the same, etc

[ed120800]

@EddieE 

This scenario only happened on the first and last question. 

Let's see if I can found out what happen. 

[ed120800]

@EddieE 

I figure out the root cause. I copy your code twice "on select" and "on change" in dropdown. 

Thank you for your advice 

[EddieE]

@ed120800 

Ah yes, that will do it! Well done on solving it.

[ed120800]

@EddieE 

Is it possible to default hide Q2 ,Q4 ,Q6 ,Q8 and show the question only when "I do not consent" was selected. 

Also does the code still work if I change to radio instead of drop box?

Thanks 

[EddieE]

@ed120800 

Yes. The App OnStart code sets this up for you, in that it auto hides the second questions before you start. If you are in Edit mode you may need to re-run the App OnStart periodically to set this up each time you test?

Re Radio Button - Yes, it will work. You will need to change the OnChange code to this

With(
    {
        wQuestionNum: "Question" & Value(Substitute(ThisItem.Title, "Question", ""))+1
    },
    If(
        Self.Value = "I do not consent" && CountRows(Filter( colChoiceResponses, Title = wQuestionNum ))=1,
        RemoveIf( colChoiceResponses, Title = wQuestionNum),
        Collect(
            colChoiceResponses,
            {
                Title: wQuestionNum
            }
        )
    )
)

[ed120800]

@EddieE 

Thank you for your advice 

I have got a new request. Any chance to make Q2 , Q4, Q6, Q8 "Required" to Yes if ""I do not consent" was selected ?

[EddieE]

@ed120800 

This may work

With(
    {
        wQuestionNum: "Question" & Value(Substitute(ThisItem.Title, "Question", ""))+1
    },
    If(
        Self.Selected.Value = "I do not consent" && CountRows(Filter( colChoiceResponses, Title = wQuestionNum ))=1,
        RemoveIf( colChoiceResponses, Title = wQuestionNum);
        // Update 'Required' to "Yes"
        UpdateIf( colData, Title = wQuestionNum, {Required: "Yes"}),
        Collect(
            colChoiceResponses,
            {
                Title: wQuestionNum
            }
        );
        // Update 'Required' to "No"
        UpdateIf( colData, Title = wQuestionNum, {Required: "No"})
    )
)

Just take care as this may affect other logic in your app - not sure because I'm unsure about all of the processes involved.

[ed120800]

@EddieE 

I have run a few tests last night, the filter function only works on preview in when editing the app. 

Once I publish and run the app the follow up question will only hide on the 1st click of "I have consented" in each question. The follow up question won't show up again when I change the option to " I do not consent".

Do you think it is related to the code on "OnStart"