Connect Multiple Forms to Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2463105%22%20slang%3D%22en-US%22%3EConnect%20Multiple%20Forms%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2463105%22%20slang%3D%22en-US%22%3E%3CP%3ESo%20a%20function%20in%20Google%20Forms%20that%20I%20use%20is%20connecting%20multiple%20forms%20to%20one%20spreadsheet%20as%20different%20tabs.%26nbsp%3B%20The%20forms%20will%20then%20automatically%20update.%26nbsp%3B%20My%20school%20district%20is%20trying%20to%20make%20the%20complete%20switch%20to%20Microsoft%2C%20and%20I%20need%20to%20know%20if%20forms%20is%20capable%20of%20doing%20this%20function.%26nbsp%3B%20I%20am%20a%20Special%20Education%20teacher%2C%20so%20I%20need%20all%20of%20the%20data%20I%20collect%20for%20my%20students%20in%20one%20place%20for%20doing%20their%20IEPs.%26nbsp%3B%20How%20would%20I%20accomplish%20this%20task%3F%20Thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2463105%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EEducation%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESurvey%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2463158%22%20slang%3D%22en-US%22%3ERe%3A%20Connect%20Multiple%20Forms%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2463158%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1082464%22%20target%3D%22_blank%22%3E%40lysamalaise%3C%2FA%3E%26nbsp%3BNo%2C%20on%20its%20own%20Forms%20cannot%20do%20that.%20You%20would%20need%20a%20flow%20in%20Power%20Automate%20to%20save%20the%20responses%20to%20each%20form%20to%20an%20excel%20spreadsheet%20on%20OneDrive.%20That%20spreadsheet%20would%20need%20to%20have%20a%20table%20in%20each%20sheet%20that%20the%20flow%20could%20add%20the%20form%20data%20to.%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

So a function in Google Forms that I use is connecting multiple forms to one spreadsheet as different tabs.  The forms will then automatically update.  My school district is trying to make the complete switch to Microsoft, and I need to know if forms is capable of doing this function.  I am a Special Education teacher, so I need all of the data I collect for my students in one place for doing their IEPs.  How would I accomplish this task? Thank you.

6 Replies

@lysamalaise No, on its own Forms cannot do that. You would need a flow in Power Automate to save the responses to each form to an excel spreadsheet on OneDrive. That spreadsheet would need to have a table in each sheet that the flow could add the form data to.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Approximately how long would it take to do each separate form flow? I have been tasked with starting this up for the entire SPED department, which is about 15 people, and there are some who literally can't set up a flow on their own, so I would have to do their kids as well.

@lysamalaise unless they are familiar with Power Automate then they won't be able to do it. That's not surprising or a criticism of them; I am in a company of over 1000 and I am basically the only one who can build apps & flows, manage SharePoint etc. That's just how life is. Others have their own jobs to get on with and don't have the time or willpower to learn a new Microsoft app.

 

Each flow would only take about 10 minutes to set up and test with you as the owner. The others don't need to build any flows. I can give you some screenshots of what you need to do, or alternatively we could have a zoom call with screenshares to demonstrate how this is done.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

That would be awesome. A zoom call might be preferred, I ask a lot of questions. Are you available Monday at 8:00 EDT?
No, that would be the middle of the night for me.

@RobElliott oic.

I'm available now.  Don't know your schedule, but nbd if it doesn't work out.