I have a form for work uniform choices. It has sections for 10 items. If they chose to say they don't require any more items they can submit the form, if they chose they do need more items then the next section becomes available.
I have a flow for the first section to auto populate an excel form. How would I have it to that each section fills a line on the excel table? And how would this work on a per submission basis?
I have been searching the net and so far have not found anything.
I did debate just having them submit the form each time for each item, but they are already grumpy as it is at having to use technology.
Ah ok. I have my form in sections. First section is Item 1, second is item 2 and so on. So when they answer section one its Item 1:type. When they answer section 2, it's Item 2:type.
Would I just have it as the switch is that they pick from that field, then a switch for items 1-10?
No you've got that wrong. The switch doesn't need to have anything to do with if they want to order more, that is handled by the branching in the form. You just need the switch to look at whether they want to order a shirt or trousers etc, with 1 switch for each type of item they want to order and a create item action to add the item they want to order to the list.
Thanks. It seems to accept it ad says the flow is working, but it doesn't return the second row to the excel sheet. I put eh switch in for when they select if they need to order more. They say yes, then I put to get response details and again add row to excel sheet. I have tried it without the get response and it doesn't take the second lot o selections either way.
@Sbrady236 the way I would do this (other solutions are available) is to use a series of Switch controls based on each question. In the image below it creates a new SharePoint list item, but the principle is the same for Excel. You'd then click New Step to add the next switch control and so on.
Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.