Can I do what I need with Microsoft Forms?

%3CLINGO-SUB%20id%3D%22lingo-sub-1354569%22%20slang%3D%22en-US%22%3ECan%20I%20do%20what%20I%20need%20with%20Microsoft%20Forms%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1354569%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%3EGood%20morning%2C%20I%20would%20like%20to%20have%20an%20online%20form%2C%20in%20which%20the%20collected%20information%20is%20inserted%20directly%20into%20an%20excel%20file%2C%20which%20will%20be%20placed%20on%20Onedrive.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EFor%20example%2C%20in%20the%20excel%20file%20I%20will%20have%20a%20database%20of%20a%20construction%20work.%3C%2FSPAN%3E%20%3CSPAN%3EAt%20the%20end%20of%20the%20day%2C%20the%20person%20in%20charge%20of%20the%20work%20would%20make%20a%20report%20in%20the%20%22Forms%22%2C%20whose%20answers%20would%20be%20inserted%20in%20excel.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3ETwo%20questions%3A%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E1-%20Is%20it%20possible%20with%20Microsoft%20365%20Family%3F%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E2-%20The%20sheet%20where%20the%20information%20will%20be%20stored%2C%20in%20the%201st%20Line%2C%20%22must%22%20have%20the%20header%20with%20the%20fields%20right%20away%3F%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EThanks%20for%20the%20help%20you%20can%20give%20me.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1354569%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-1354687%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20I%20do%20what%20I%20need%20with%20Microsoft%20Forms%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1354687%22%20slang%3D%22en-US%22%3E%3CP%3EYes%2C%26nbsp%3B%20I%20believe%20you%20can%20however%20you%20would%20have%20to%20first%20create%20the%20Form%20as%20a%20Group%20Form%20make%20sure%20you%20see%20the%20excel%20logo%20with%20the%20cloud%20in%20the%20response%20tab%20on%20the%20Form%20also%20make%20sure%20you%20create%20it%20in%20the%20correct%20Group.%20I%20normally%20make%20my%20Forms%20from%20The%20Teams%20App.%20The%20Excel%20file%20will%20then%20be%20linked.%20You%20can%20then%20copy%20any%20columns%20%2F%20data%20into%20that%20Workbook%20you%20can%20even%20rename%20the%20work%20book%20and%20change%20the%20column%20titles%20with%20out%20effecting%20fictionality%20add%20conditional%20formatting%20etc.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20do%20not%20know%20if%20there%20is%20a%20way%20to%20link%20and%20existing%20spreadsheet%20to%20a%20Form.%20If%20there%20is%20I%20would%20like%20to%20know%20but%20this%20works.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F645059%22%20target%3D%22_blank%22%3E%40Carlos_Soares%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1355135%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20I%20do%20what%20I%20need%20with%20Microsoft%20Forms%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1355135%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F645059%22%20target%3D%22_blank%22%3E%40Carlos_Soares%3C%2FA%3E%26nbsp%3Byou%20can%20do%20this%20by%20linking%20the%20form%20to%20the%20spreadsheet%20with%20a%20simple%20flow%20in%20Power%20Automate.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOnce%20you've%20created%20your%20form%20you%20then%20need%20to%20create%20your%20spreadsheet%20and%20format%20it%20as%20a%20table.%20Then%20create%20an%20instant%20blank%20flow%20as%20follows%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Flow.png%22%20style%3D%22width%3A%20700px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F188415i45EC90AC988CE0B4%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Flow.png%22%20alt%3D%22Flow.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20flow%20takes%20the%20form%20response%20and%20adds%20a%20row%20into%20the%20excel%20table%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22forms-excel.gif%22%20style%3D%22width%3A%20600px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F188413iE8D6DEFBFCBD85DD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22forms-excel.gif%22%20alt%3D%22forms-excel.gif%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%3CLINGO-SUB%20id%3D%22lingo-sub-1359542%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20I%20do%20what%20I%20need%20with%20Microsoft%20Forms%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1359542%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3B%20%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%3EGood%20Morning%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EThanks%20for%20the%20answers%20and%20help%2C%20but%20now%20I%20need%20to%20know%20a%20few%20more%20things%20about%20Office%20and%20Power%20Automate.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3ERight%20now%20I%20have%20subscribed%20to%20Microsoft%20Office%20365%20Family.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3EIs%20there%20an%20Office%20365%20subscription%20that%20has%20already%20included%20Power%20Automate%3F%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EIf%20I%20have%20to%20subscribe%20to%20Power%20Automate%2C%20do%20I%20need%20to%20have%20an%20account%20for%20each%20person%20responsible%20for%20the%20Work%20that%20I%20have%3F%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3EIf%20I%20have%2010%20works%20going%20on%20in%20different%20countries%2C%20do%20I%20have%20to%20have%2010%20accounts%3F%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3EThank%20you%20for%20your%20help.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1359574%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20I%20do%20what%20I%20need%20with%20Microsoft%20Forms%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1359574%22%20slang%3D%22en-US%22%3EGood%20Morning%3CBR%20%2F%3E%3CBR%20%2F%3ESorry%20for%20my%20doubts%2C%20but%20this%20is%20the%20first%20time%20that%20I'm%20trying%20to%20use%20forms%20over%20the%20internet.%3CBR%20%2F%3EUnlike%20Rob%2C%20who%20advised%20you%20to%20use%20Power%20Automate%2C%20in%20your%20words%2C%20can%20I%20also%20do%20it%20for%20Teams%20and%20Excel%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1359594%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20I%20do%20what%20I%20need%20with%20Microsoft%20Forms%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1359594%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20an%20educational%20licence%20this%20works%20for%20Edu%20and%20Enterprise%20licences%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20are%20trying%20to%20use%20Office%20365%20for%20business%20purposes%20a%20family%20licence%20will%20be%20restrictive%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%20method%20should%20work%20I%20can%20not%20advise%20any%20further.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20might%20need%20to%20post%20in%20Power%20Automate%20group%20for%20better%20replies%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F645059%22%20target%3D%22_blank%22%3E%40Carlos_Soares%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Good morning, I would like to have an online form, in which the collected information is inserted directly into an excel file, which will be placed on Onedrive.

For example, in the excel file I will have a database of a construction work. At the end of the day, the person in charge of the work would make a report in the "Forms", whose answers would be inserted in excel.

Two questions:
1- Is it possible with Microsoft 365 Family?
2- The sheet where the information will be stored, in the 1st Line, "must" have the header with the fields right away?

Thanks for the help you can give me.

5 Replies

Yes,  I believe you can however you would have to first create the Form as a Group Form make sure you see the excel logo with the cloud in the response tab on the Form also make sure you create it in the correct Group. I normally make my Forms from The Teams App. The Excel file will then be linked. You can then copy any columns / data into that Workbook you can even rename the work book and change the column titles with out effecting fictionality add conditional formatting etc. 

 

I do not know if there is a way to link and existing spreadsheet to a Form. If there is I would like to know but this works. 

 

@Carlos_Soares 

@Carlos_Soares you can do this by linking the form to the spreadsheet with a simple flow in Power Automate.

 

Once you've created your form you then need to create your spreadsheet and format it as a table. Then create an instant blank flow as follows:

Flow.png

 

The flow takes the form response and adds a row into the excel table:

forms-excel.gif

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

@RobElliott  Good Morning

Thanks for the answers and help, but now I need to know a few more things about Office and Power Automate.

Right now I have subscribed to Microsoft Office 365 Family.

Is there an Office 365 subscription that has already included Power Automate?

If I have to subscribe to Power Automate, do I need to have an account for each person responsible for the Work that I have? If I have 10 works going on in different countries, do I have to have 10 accounts?

Thank you for your help.

Good Morning

Sorry for my doubts, but this is the first time that I'm trying to use forms over the internet.
Unlike Rob, who advised you to use Power Automate, in your words, can I also do it for Teams and Excel?

Thank you

Hello

 

I am using an educational licence this works for Edu and Enterprise licences 

 

If you are trying to use Office 365 for business purposes a family licence will be restrictive 

 

Rob method should work I can not advise any further.

 

You might need to post in Power Automate group for better replies 

 

@Carlos_Soares