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

%3CLINGO-SUB%20id%3D%22lingo-sub-1583290%22%20slang%3D%22en-US%22%3EOrder%20form%20to%20collect%20multiple%20names%20to%20be%20exported%20in%20to%20one%20column%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1583290%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20I%20set%20a%20function%20to%20have%20a%20repeating%20set%20of%20questions%20that%20will%20export%20each%20like%20question%20into%20one%20excel%20column%3F%3C%2FP%3E%3CP%3EIt%E2%80%99s%20a%20school%20meal%20order%20form%3A%20I%20would%20like%20%26nbsp%3Bto%20have%20the%20family%20submit%20one%20form%20with%20all%20their%20students%20meal%20choices.%20Current%20I%20have%204%20questions%20(%20First%20name%20%2C%20last%20name%2C%20ID%20number%2C%20number%20of%20milks)%20Follow%20by%20the%20branching%20question%2C%20do%20you%20have%20more%20students%20to%20enter%3F%20%26nbsp%3BIf%20yes%20those%20same%20question%20are%20asked.%20When%20I%20export%20the%20data%2C%20I%20would%20like%20to%20have%20all%20the%20students%20names%20in%20the%20same%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20some%20hidden%20function%20I%20don%E2%80%99t%20know%20about%20that%20would%20allow%20for%20a%20repeating%20question%20(%20that%20would%20then%20population%20the%20same%20date%20column%20apron%20export%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1583290%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ERepeating%20question%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1583884%22%20slang%3D%22en-US%22%3ERe%3A%20Order%20form%20to%20collect%20multiple%20names%20to%20be%20exported%20in%20to%20one%20column%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1583884%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F753430%22%20target%3D%22_blank%22%3E%40Mpaul007%3C%2FA%3E%26nbsp%3Brepeating%20questions%20are%20not%20possible%20with%20Microsoft%20Forms.%20There%20are%20various%20Uservoice%20requests%20for%20this%20which%20you%20can%20vote%20for%2C%20for%20example%20at%26nbsp%3B%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fmicrosoftforms.uservoice.com%2Fforums%2F386451-welcome-to-microsoft-forms-suggestion-box%2Fsuggestions%2F36648085-repeating-section-content-control-for-repetitive-q%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmicrosoftforms.uservoice.com%2Fforums%2F386451-welcome-to-microsoft-forms-suggestion-box%2Fsuggestions%2F36648085-repeating-section-content-control-for-repetitive-q%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23333399%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Visitor

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
Highlighted

@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