Hi all,
I have a Form with several questions (mostly "choose one" or text), but one is a multiple-choice style question. I have this connected to a SharePoint as I am trying to create sort-of a ticketing system. However, I need the multiple-choice answers to appear individually in the SharePoint, as in, one line per multiple-choice answer. I would like for all of the information of the Form to translate to each multiple-choice answer though. For example, in a Form like the below, where the respondent chose "Apple" and "Banana" for Question 3:
Question 1: ID
A1
Question 2: Date
1/3/2024
Question 3: Favorite Fruit
Apple
Banana
Strawberry
I would like the SharePoint to present the data as following:
Date ID Favorite Fruit
1/3/2024 A1 Apple
1/3/2024 A1 Banana
Is this possible? If so, how can one do this? I'm new to SharePoint/Power Automate, so if you can explain this like you would to a 5th grader, I would appreciate it.
