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?

[EddieE]

@ed120800 

Yes this is possible. Will depend on the logic you have setup when a User selects a Q1 option. If you share some code I can help further - sorry, I'm not going to watch that video.

[ed120800]

@EddieE 

Let me give you some detail of my case. 

My app will connect to 2 SharePoint list ("Form Template" and "Form Result"). 

1.  Form Template <- It store the survey questions and related attribute (e.g Column Type, Required) 

I use collection to get the SharePoint list column and add 1 column "Data" in the table. 

------------Code Start ------------------

OnStart=

ClearCollect(
colFormTemplate,
AddColumns(
ShowColumns(
'Form Template 4',
Title,
Question,
Required,
ColumnType,
Choices
),
Data,
""
)

------------Code End------------------

2. I have a button with below code to start the dynamic form on gallery

------------Code Start ------------------

OnSelect =

ClearCollect(
colData,
colFormTemplate
);

Set(varFormMode,"New");
Set(varItem,Defaults('Form Result 4'));
Navigate(Dynamic);

------------Code End------------------

3. The gallery will have 3 object to display question and collect response ( textlabel , drop down , textinput) 

    I use below code the get the gallery and this will list out all question by rrder 

------------Code Start ------------------

   Item = ColData

------------Code End -------------------

I have no idea how to apply skip logic in this gallery. 

This is what I have right now. 

[EddieE]

@ed120800 

Ok, thanks. I don't think you are looking for 'skip' but to Filter the gallery. Try this

// OnChange of DropDown inside the gallery
Set( vQuestion1Response, Self.Selected.Value);

// Items property of the question gallery
Filter(
    colFormTemplate,
    (vQuestion1Response <> "I do not consent" || Title <> "Question2")
)

Note: the second part of the filter will likely give you a delegation warning for using '<>' but you can ignore this if you have less than 2,000 questions - assuming you have set the Data row limit to the Max 2,000.

[ed120800]

@EddieE 

I have tried to change the code but didn't work out.

I change the collection from colFormTemplate to colData as I have add a new collection in #2

[EddieE · Accepted solution]

@ed120800 

Sorry, I wasn't focusing on your data. I think the best option is to create a collection of Questions that need to be completed when a user selects "I do not consent" to the question before it.

To help do this, I'd suggest adding a column to your List called 'ConsentReqd' of Type TEXT. Then, for the questions that need to be completed if the previous one was selected as "I do not consent", set these to "Yes". All other questions set to "No". Here's some example data of what I mean

ClearCollect(
    colData,
    {Title: "Question1", ColType: "Choice", Required: "Yes", Choices: "I have consented;I do not consent", ConsentReqd: "No", Data: ""},
    {Title: "Question2", ColType: "Text", Required: "Yes", Choices: "NA", ConsentReqd: "Yes",Data: ""},
    {Title: "Question3", ColType: "Choice", Required: "Yes", Choices: "I have consented;I do not consent", ConsentReqd: "No", Data: ""},
    {Title: "Question4", ColType: "Number", Required: "Yes", Choices: "NA", ConsentReqd: "Yes", Data: ""},
    {Title: "Question5", ColType: "Text", Required: "Yes", Choices: "NA", ConsentReqd: "No", Data: ""}
);

Then to the App OnStart add this

ClearCollect(
    colChoiceResponses,
    ShowColumns(Filter( colFormTemplate, ConsentReqd = "Yes"), Title)
)

Gallery Items becomes

Filter(
    colData,
    !(Title in colChoiceResponses.Title)
)

OnChange of your Dropdown

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),
        Collect(
            colChoiceResponses,
            {
                Title: wQuestionNum
            }
        )
    )
)

There are a number of assumptions with the above:

- the consent question (ie ConsentReqd = "Yes") ALWAYS follows the Choice question where consent is being asked - eg If Consent being asked = Question1 then the related question must be Question2

- The consent Choices are ALWAYS "I have consented;I do not consent" and in this order

- your ShowColumns() must always include the field 'Title'

- there maybe other assumptions I've forgotten

Give that a go and see how you get on

[ed120800]

@EddieE 
May I know where to put below code? 

ClearCollect(
    colData,
    {Title: "Question1", ColType: "Choice", Required: "Yes", Choices: "I have consented;I do not consent", ConsentReqd: "No", Data: ""},
    {Title: "Question2", ColType: "Text", Required: "Yes", Choices: "NA", ConsentReqd: "Yes",Data: ""},
    {Title: "Question3", ColType: "Choice", Required: "Yes", Choices: "I have consented;I do not consent", ConsentReqd: "No", Data: ""},
    {Title: "Question4", ColType: "Number", Required: "Yes", Choices: "NA", ConsentReqd: "Yes", Data: ""},
    {Title: "Question5", ColType: "Text", Required: "Yes", Choices: "NA", ConsentReqd: "No", Data: ""}
);

[EddieE · Accepted solution]

@ed120800 

You don't need to use that code. It is just example code - a mock-up of your SharePoint List - to demo how I used the other bits of code

[ed120800]

@EddieE 

Thanks for reply.

I try the code and it show error on the dropdown 

[ed120800]

@EddieE 

It works out when I change "value" to "result" 

You are awesome.

Many Thanks