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?
Solved! Go to Solution.
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 )
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.
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 ?
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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!