Form data into excel using Power Automate

Question

Hello All!

I have a question that i am hoping someone here may be able to help. I am kind of new with Power Automate and have been trying to figure this one out for quite some time without success.

I have a form that i have multiple questions, each question gives a choice to the responder in number. Each question is related to a product and theres a drop down that allows them to select 0,1,2,3. some items goes up to 12, some limit at 2 and some are 3.

Example:

How many Oreo Cookie Single Serve?

(dropdown)

1

2

3

How many Sour Patch Kids?

(dropdown)

1

2

3

4

5

6

7

8

I have several Items that i divided into categories in the forms (Cookie, Candy, Gum, etc), each question has the item name in the question and the answer is a number (qty). 101827-question1.png

I am trying to bring to excel that data showing each of these items in a different row (not columns), example: (

NAME EMAIL ADDRESS CITY ITEM QTY

John Smith john.smith@sharp .com 123 Street st Town Oreo Cookie Single Serve 2
John Smith john.smith@sharp .com 123 Street st Town Sour Patch Kids 6

Pretty much each positive answer (they selected any number) would be on its own row with qty and item while 101827-question1.pngrepeating the responder's information.!

Answer 1

Power automate is not currently supported here on QnA. The product group actively monitors questions in dedicated forums here.
https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

--please don't forget to upvote and Accept as answer if the reply is helpful--