I have a SharePoint list "questions" wherein there are 4 columns namely question group, question, answer type, and answer. I'm using a gallery with labels and input fields for the questions and answer fields respectively, based on the answer type(choice, checkbox, text input, date input). I want to be able to show/hide some questions in the gallery based on other questions' responses.
I tried adding columns named expected answer, dependent question, and show question. I stored the sp list in a collection and filtered based on show question. This works well. There are 3 questions Q1, Q2, Q3. Q2 is dependent upon Q1, Q3 is dependent upon Q2. If the answer in q1 = expected answer then q2 is visible and if the answer in q2 = expected answer then q3 is visible. But in case q1,q2,q3 are visible and I change q1s answer such that answer in q1 != expected answer then q2 is not visible but q3 is visible. I want to be able to hide q3 as well.

Report
All responses (
Answers (