Forum Discussion
Using one Form to collect multiple responses
JoshQLDEDU you said "I would like to make a form that gives the user an option to repeat a set of questions, but providing different responses with each subsequent iteration." This is not possible; Forms is a simple one-pass submission forms and there is no way to iterate through it multiple times.
Actually a flow in Power Automate wouldn't solve this either; all it does is to take the forms response that has been submitted and then do something with it, for example save it to SharePoint, send out an email etc.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
JoshQLDEDU you said "I would like to make a form that gives the user an option to repeat a set of questions, but providing different responses with each subsequent iteration." This is not possible; Forms is a simple one-pass submission forms and there is no way to iterate through it multiple times.
Actually a flow in Power Automate wouldn't solve this either; all it does is to take the forms response that has been submitted and then do something with it, for example save it to SharePoint, send out an email etc.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
RobElliott, Thanks so much for the quick reply.
While not being able to do what i'd like to is a shame, getting clarification that I wasn't just missing something makes it a lot easier to "let go" of the problem and work on a different method.
Actually a flow in Power Automate wouldn't solve this either; all it does is to take the forms response that has been submitted and then do something with it, for example save it to SharePoint, send out an email etc.
I haven't had the opportunity to tinker with Power Automate, so I haven't been able to get a grasp of its capabilities and limitations. From examples I have seen I thought It would be possible to get a flow to recognise when a yes response is made to a certain question (Would you like to enter another student's info?) then present a new Form to the user via an email. Perhaps even be able to generate a form that by scraping answers from the initial form and pre-fill the repetitive sections.
Or use Automate to extract information from a Form that has a "dumb" repeat (a series of duplicated sections, say, 20) by getting it to place responses to questions in defined table columns, but ignore empty responses. Then some other action to insert <information from section 1> n times, with n being the number of "dumb repeats" with filled fields.
Aaaaanyway, i really appreciate your help. Fingers crossed that one day my place of work decides to let staff use Automate so I can give it a whirl.
Much appreciated,
- Josh
"get a flow to recognise when a yes response is made to a certain question (Would you like to enter another student's info?)" - yes it can do that easily. But why not just add a custom message and then the user click the Submit another response link. Doesn't require a flow at all.
"then present a new Form to the user via an email." - see my answer above
"Perhaps even be able to generate a form that by scraping answers from the initial form and pre-fill the repetitive sections." - it is not possible to pre-populate anything in Forms.You mention having about 20 sections. Be careful, you have a hard limit of 100 questions in a form and that reduces quickly if you use likert questions as each statement counts as a question.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
