Creating new Forms generates a generic Excel result sheet (not associated with Form)

Question

Hello Forms Community,&nbsp;I have a problem I can't find an answer for.&nbsp; I think it might be a bug?&nbsp; Here it is...&nbsp;When I go to create a Group Form and then go to my Onedrive Group location to view the resulting excel sheet, I open the sheet and it's a generic workbook that has a table in it with unrelated columns to my form.&nbsp; I'm not sure how else to word this, but I'll attempt to add screenshots below.&nbsp;From a step perspective here is what I do:Go to&nbsp;forms.office.com and click Group formsClick New group Form buttonAdd a title "Favorite Color"Add Q1 as text, required. Label it "Last Name"Add Q2 as text, required. Label it "Favorite Color"Then I went to my Onedrive account and found a newly created excel file called "Untitled Form.xlsx"I open this file and I get the screen I attached here.&nbsp; It's a workbook that has different column headings than are on my form.&nbsp; The column headers are "Start time", "Completion time", "Email", "Name"&nbsp; and the odd part is that the default selected cell is I16.So no matter what form I create, and no matter what responses I give to my forms, I get the same exact spreadsheet as described in step 7 above with no data in the sheet and the same column names I described in step 7 above.&nbsp;Wondering if anyone else has this issue?&nbsp; Thanks!

es_en · Answer

OK so we got passed around to 3 different case managers; Office 365, Excel, SharePoint...none of them had real answers.&nbsp; So the final answer we got was "It's broken by design."&nbsp; I think what she meant was, you are a Government License and the feature for syncing the form to a spreadsheet is something you don't have access to (even though it creates a blank .xlsx worksheet when creating a new form).&nbsp;So I guess we just don't have the backend sync connectors because we are a lower level license.&nbsp; I asked why it creates the spreadsheet giving the impression that it should work...and again I got the answer "It's by design".&nbsp; So we will wait until it shows up in another 2 years.&nbsp;Thanks for trying to help.&nbsp; I'm thinking perhaps there might be a workaround using Flow, so that is what I'm looking into now.

es_en · Answer

OK a new development on this.&nbsp; So yesterday I went to one of the test forms I had created for the MS engineer on one of the support calls.&nbsp; It's a Group Form, really simple one.&nbsp; I filled it out, then went to check the generic sheet it had created when I originally created the form...and my answer was there!!!&nbsp;So I then created a new form again, really simple.&nbsp; I put a response in, then went to Onedrive and saw the new generically named spreadsheet, opened it and saw the response.&nbsp; Then, I opened a dedicated window for the spreadsheet, and in another window responded to the form...and within 10seconds I saw a flash where a box came up that said [SharePoint is editing the document] and the response showed up below the other.&nbsp; OK this is what I was expecting...so it looks like the connector piece is getting rolled out to Government accounts?&nbsp;The only thing missing now is the naming of the sheet.&nbsp; I'd expect the name of the sheet to match the name I gave the form.&nbsp; It does work in my personal government form creation, just not in the Group area.&nbsp;I'll update you if (when) the naming gets fixed too.

damien_rosario · Answer

Hi&nbsp;es_en&nbsp;&nbsp;Based on your scenario I think you're getting confused between making form in Office 365 and doing it via OneDrive. Creating a form in Group Forms does not place anything into OneDrive, but you may find it in a Document library within the SharePoint group that it's associated with.&nbsp;Try this instead when creating a new form:1. Go to the SharePoint document library that you would like to house the form results in.2. Go to + New &gt; Forms for Excel.3. You must provide a name for the Excel spreadsheet where the results will be stored in. Click Create.4. You will now be taken to the new form to set up as needed.5. Visit your SharePoint document library and open the Excel file to see your results.&nbsp;This method should make it easier to create the form and to find the results in SharePoint.&nbsp;Hope that makes sense and helps you!&nbsp;CheersDamien&nbsp;

es_en · Answer

&nbsp;Hi Damien thanks for your response.&nbsp; We've actually opened a ticket with Microsoft as we aren't seeing the Forms option in our +New button.So when I click the +New button I see this:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Notice, we don't see Forms, but rather the older version of forms which is Excel survey.&nbsp; I was told that perhaps it's because we are a government entity and that we are the last to get new features?&nbsp; We have an Office 365 GCC G3 license.&nbsp;The odd part is I see Forms in our waffle and can launch it and create the nice new format of Forms.&nbsp; But in our version of Excel online I only see the old Survey button.&nbsp; So there is obviously some disconnect there and thus possibly why it creates just a generic .xlsx file called "Untitled form.xlsx" without any of my fields I created in my form.&nbsp;I'll update this post once we speak with Microsoft and find out a solution.

damien_rosario · Answer

Hi&nbsp;es_en&nbsp;&nbsp;I'm not really sure what's going on but would be interested to learn the answer when you have one.&nbsp;In the meantime have a terrific weekend ahead!&nbsp;CheersDamien

Forum Discussion

Creating new Forms generates a generic Excel result sheet (not associated with Form)

Share

Resources