Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Linking Multiple Form Question Answers (from one form) into one SharePoint List Column

Posted on by
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!


 
  • Suggested answer
    SaiRT14 Profile Picture
    SaiRT14 1,278 on at
    Linking Multiple Form Question Answers (from one form) into one SharePoint List Column
    Efficient solution could be:
     
    Define the mapping of tier and experiences in the flow as a JSON object:
    {
      "Bronze": {
        "A": "Experience A",
        "B": "Experience B"
      },
      "Gold": {
        "A": "Experience A",
        "B": "Experience B",
        "C": "Experience C"
      },
      "Diamond": {
        "X": "Experience X",
        "Y": "Experience Y"
      }
    }
     
    Use a Parse JSON action in Power Automate. Reference the user’s Tier and Experience responses dynamically in the JSON to get the correct value.
     
    Use the Set Variable action to populate the value based on the parsed JSON.
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,487

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,014

Leaderboard