Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Order form to collect multiple names to be exported in to one column?

Copper Contributor

Can I set a function to have a repeating set of questions that will export each like question into one excel column?

It’s a school meal order form: I would like  to have the family submit one form with all their students meal choices. Current I have 4 questions ( First name , last name, ID number, number of milks) Follow by the branching question, do you have more students to enter?  If yes those same question are asked. When I export the data, I would like to have all the students names in the same column.

 

Is there some hidden function I don’t know about that would allow for a repeating question ( that would then population the same date column apron export?

 

1 Reply

@Mpaul007 repeating questions are not possible with Microsoft Forms. There are various Uservoice requests for this which you can vote for, for example at  https://microsoftforms.uservoice.com/forums/386451-welcome-to-microsoft-forms-suggestion-box/suggest...

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User