Multiple Questions to new row.

%3CLINGO-SUB%20id%3D%22lingo-sub-2182625%22%20slang%3D%22en-US%22%3EMultiple%20Questions%20to%20new%20row.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2182625%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20everyone.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20a%20quick%20question.%20I%20have%20a%20form%20where%20we%20are%20gathering%20IMEI%20info%20from%20routers%20on%20hand.%20The%20only%20way%20to%20do%20this%20in%20MS%20Forms%20is%20to%20have%20a%20separate%20question%20for%20each.%20So%20my%20question%20is%2C%20is%20there%20a%20way%20that%20each%20question%20answered%20can%20be%20added%20as%20a%20NEW%20ROW%20instead%20of%20a%20column.%20I've%20done%20something%20similar%20with%20Flow%20for%20a%20multiple%20choice%20question.%20But%20this%20one%20is%20slightly%20different.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAppreciate%20any%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2182625%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2187762%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20Questions%20to%20new%20row.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2187762%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F428448%22%20target%3D%22_blank%22%3E%40Charles665%3C%2FA%3E%26nbsp%3Bthere's%20nothing%20in%20Forms%20itself%20that%20can%20do%20this%2C%20you%20would%20need%20to%20use%20a%20flow%20but%20why%20not%20just%20have%201%20question%20on%20the%20form%20relating%20to%20each%20router%20and%20have%20the%20engineer%20submit%20it%20for%20each%20router%3F%20That%20way%20you'll%20have%20a%20separate%20row%20in%20the%20spreadsheet%20for%20each%20router.%20But%20if%20it's%20more%20complicated%20that%20that%20you'll%20need%20to%20post%20up%20an%20image%20of%20the%20form%20se%20we%20can%20take%20a%20look.%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%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hey everyone. 

 

Have a quick question. I have a form where we are gathering IMEI info from routers on hand. The only way to do this in MS Forms is to have a separate question for each. So my question is, is there a way that each question answered can be added as a NEW ROW instead of a column. I've done something similar with Flow for a multiple choice question. But this one is slightly different. 

 

Appreciate any help.

2 Replies

@Charles665 there's nothing in Forms itself that can do this, you would need to use a flow but why not just have 1 question on the form relating to each router and have the engineer submit it for each router? That way you'll have a separate row in the spreadsheet for each router. But if it's more complicated that that you'll need to post up an image of the form se we can take a look.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

@RobElliott yea that's the route we were prob gonna go. Just wondering if there was a simpler method for the end user. Appreciate you always helping me out!!