Power Platform Community Forum Thread Details

Form data into excel via automate - multiple questions into rows

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)

How many Sour Patch Kids?

(dropdown)

Here is the screenshot on how the question looks on forms, there are several similar questions with the allowed number as an answer.

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).

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	STATE	ITEM	QTY
John Smith	Email	street	town	WI	Oreo Cookie Single Serve	2
John Smith	Email	street	town	WI	Sour Patch Kids	6
John Smith	Email	street	town	WI	next item	1

Pretty much each positive answer (they selected any number) would be on its own row with qty and item while repeating the responder's information. Only items (questions) that they answered a number would show (on its own row) see below example output:

output example.JPG