question

ThiagoBidu-6443 avatar image
0 Votes"
ThiagoBidu-6443 asked DSPatrick commented

Form data into excel using Power Automate

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@cookie.com 123 Street st Town Oreo Cookie Single Serve 2
John Smith john.smith@cookie.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.101807-output-example.jpg!




not-supported
output-example.jpg (25.3 KiB)
question1.png (81.9 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

DSPatrick avatar image
0 Votes"
DSPatrick answered DSPatrick commented

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


· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank You Unfortunatelly i do not have access to that forum. i will research elsewhere.

thank you

0 Votes 0 ·

Sounds good, you're welcome. All you need to do is register.

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





1 Vote 1 ·

My company did not give access to that site. i will try a personal account Thank You!

0 Votes 0 ·
Show more comments