Hi there!
I have a Microsoft Form for people to choose the type of experience they would like to book. The form has many standard questions (Name, Date of Experience, etc). For user ease it also has branching questions.
For example: Which experience tier would you like? (Only one choice allowed)
Multiple choice options:
Bronze
Silver
Gold
Diamond
Platinum
Based on the Tier they choose, the question branches so now they can pick the experience based off the Tier they selected. Each branched question (tier) has multiple choices (some of these may be the same choices for each Tier, some may be different - only one choice allowed).
For example:
Question 1: Which experience tier would you like?
Answer: Gold
Branched Question: Which Gold Experience would you like?
Multiple Choice options:
A
B
C
D
E
Answer: C
Now when someone submits this form, I want to link the answers to a SharePoint list. I have no problem using Power Automate to link the basic questions into the list (Name, Date, etc)
However for the branching questions I do not need a column for every single branched form question. For simplicity on the List I just want to see Tier and Experience Requested.
For example:
Tier (Their choice from Question 1) Experience Requested (Their choice from the branched question)
Gold C
So whether they chose Tier Bronze, Experience Option A; Tier Diamond, Experience Option B; etc. I just need to pull the Tier into one list column (easy and already have this working), then the Experience Option into it's own list column (apparently not so easy).
Across all the Tiers there is a total of 30 different Options, so i really don't want 30 list columns hence why I am trying to pull it into one. In my Experience Requested Column in the Sharepoint list, i have entered all the options possible.
I have tried to use conditions in various ways, but just can't seem to get the Experience Requested column to populate. Appreciate any insight!