Copy form questions into another form?

%3CLINGO-SUB%20id%3D%22lingo-sub-1314181%22%20slang%3D%22en-US%22%3ECopy%20form%20questions%20into%20another%20form%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1314181%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20an%20absolute%20beginner.%26nbsp%3BMy%20work%20provides%20a%20cloud%20version%20of%20O365%20which%20includes%20Forms.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20created%20a%20form%20to%20see%20if%20I%20could%20figure%20it%20out%20on%20my%20own%20and%20it%20looks%20like%20I%20did.%20My%20problem%20is%20that%20I%20think%20I%20did%20things%20backward%20because%20the%20data%20from%20the%20form%20responses%20is%20meant%20to%20go%20into%20an%20excel%20spreadsheet.%20I%20know%20that%20if%20I'm%20in%20excel%20I%20select%20Insert%20New%20Form%20(I%20saw%20no%20option%20to%20use%20an%20existing%20form)%20and%20it%20takes%20me%20to%20forms%20and%20starts%20me%20creating%20a%20new%20form.%20The%20problem%20is%20that%20I%20already%20created%20the%20form%20and%20reaaaaally%20don't%20want%20to%20have%20to%20assemble%20it%20again%2C%20since%20it's%20long%20and%20has%20branching%20stuff.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EHow%20can%20I%20either%3A%3CBR%20%2F%3E-%20When%20I%20insert%20a%20new%20form%20in%20excel%20and%20it%20automatically%20prompts%20a%20new%20form%20creation%20to%20paste%20the%20already%20created%20form%20questions%2C%20logic%2C%20etc%20into%20the%20new%20one%3F%20or%2C%3CBR%20%2F%3E-%20Use%20the%20already%20existing%20form%20when%20wanting%20to%20add%20collected%20data%20to%20my%20existing%20excel%20spreadsheet%3F%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1314181%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-1315634%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20form%20questions%20into%20another%20form%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1315634%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F623421%22%20target%3D%22_blank%22%3E%40veroa%3C%2FA%3E%26nbsp%3Bmy%20recommendation%20is%20to%20always%20start%20from%20Forms.%20Did%20you%20see%20that%20when%20you%20are%20designing%20the%20form%20and%20testing%20it%2C%20if%20you%20go%20to%20the%20Responses%20tab%20the%20form%20is%20saved%20as%20a%20spreadsheet%20anyway%3F%20If%20you%20then%20need%20to%20put%20the%20responses%20into%20a%20different%20spreadsheet%20you'd%20need%20to%20do%20that%20with%20a%20flow%20in%20Power%20Automate%20or%20a%20copy-and-paste.%20But%20the%20spreadsheet%20of%20responses%20is%20there%20for%20you%20already.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22openSpreadsheet.png%22%20style%3D%22width%3A%20783px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F184979i3A8FAD4B8A5FFF7A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22openSpreadsheet.png%22%20alt%3D%22openSpreadsheet.png%22%20%2F%3E%3C%2FSPAN%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
Occasional Visitor

I'm an absolute beginner. My work provides a cloud version of O365 which includes Forms. 

 

I created a form to see if I could figure it out on my own and it looks like I did. My problem is that I think I did things backward because the data from the form responses is meant to go into an excel spreadsheet. I know that if I'm in excel I select Insert New Form (I saw no option to use an existing form) and it takes me to forms and starts me creating a new form. The problem is that I already created the form and reaaaaally don't want to have to assemble it again, since it's long and has branching stuff. 

How can I either:
- When I insert a new form in excel and it automatically prompts a new form creation to paste the already created form questions, logic, etc into the new one? or,
- Use the already existing form when wanting to add collected data to my existing excel spreadsheet?

1 Reply

@veroa my recommendation is to always start from Forms. Did you see that when you are designing the form and testing it, if you go to the Responses tab the form is saved as a spreadsheet anyway? If you then need to put the responses into a different spreadsheet you'd need to do that with a flow in Power Automate or a copy-and-paste. But the spreadsheet of responses is there for you already.

 

openSpreadsheet.png

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User