Converting individual Forms Responses to Excel Spreadsheets

[CoryC]

Hello,

I'm looking into making a flow that takes a form for purchasing something in our company. I have a few questions about constructing this based on the form I've made. Sometimes our company needs to order multiple things, so I made the form into sections that act as separate things they can order. Thing is, sometimes they don't need to use all the sections, they may need to use just two or five.

The spreadsheet it makes has all of the sections' questions, which can make the spreadsheet hard to read. Is there a way to convert that response to a spreadsheet that only has the questions answered on it and split up by sections?

[rhamza]

Good afternoon @cory 

Are you referring to a form inside Microsoft Forms ? 

[CoryC]

Yes, sorry for not mentioning that. This is being done with Microsoft Forms.

[rhamza]

@CoryC 

There is actually multiple ways to do what you need.

But first, did you look into the feature "add branching" ? ( Basically, when you choose add branching, you can make a user skip an entire list or even end the form right there )

https://support.microsoft.com/en-us/office/use-branching-logic-in-microsoft-forms-16634fda-eddb-44da...

[CoryC]

That is actually how I set up the form to make the multiple sections. The thing is, even with branching, the spreadsheet the responses make when they're posted still has all the sections, even the branched off ones, which makes reading the spreadsheet it creates cumbersome and inefficient. I wanted to see if there was a more elegant way to make the spreadsheets from responses that takes into consideration that not all sections are guaranteed to be filled out.

[rhamza]

@CoryC 

And what is the end result,

1) You wish to receive an excel spread sheet every time someone complete the form  right ?

2) What do you intend to do with spreadsheet ? ( Creating a task, ordering the product, having approval ? )

3) Do you absolutely need it to be excel or an email could do the job ? 

[CoryC]

Yes, I'd like an individual spreadsheet for every response. Ultimately, they'll just need to be email-able, since I can create flow for what happens after that with no issue, I just need the initial information put in a form that my PO department can read cleanly. It honestly doesn't matter to me if it's in a spreadsheet or just in an email. I just went with spreadsheets since that seemed the most viable for the moment, but they do need to only have information for questions that were actually filled out, which can vary from response to response.

[rhamza]

@cory 

I'll get back to you in 20mins.

[rhamza · Accepted solution]

@CoryC 

I do not know how long is your form but :

You have this 1st option using Email