Forum Discussion
Creating new Forms generates a generic Excel result sheet (not associated with Form)
Hello Forms Community, I have a problem I can't find an answer for. I think it might be a bug? Here it is... When I go to create a Group Form and then go to my Onedrive Group location to vi...
Hi es_en
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.
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 > 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.
This method should make it easier to create the form and to find the results in SharePoint.
Hope that makes sense and helps you!
Cheers
Damien
Hi Damien thanks for your response. 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:
Notice, we don't see Forms, but rather the older version of forms which is Excel survey. I was told that perhaps it's because we are a government entity and that we are the last to get new features? We have an Office 365 GCC G3 license.
The odd part is I see Forms in our waffle and can launch it and create the nice new format of Forms. But in our version of Excel online I only see the old Survey button. 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.
I'll update this post once we speak with Microsoft and find out a solution.
I'm going to bet that you're right about the feature availability lag in the government tiers--Microsoft Forms was available for quite some time before the ability to create a Form from either OneDrive or a SharePoint Group site came into being. I hope I'm wrong and maybe your ticket with Microsoft will show something else.
I had a call with Microsoft today regarding our problem. We were able to screenshare and demonstrate our issue. Our tech agent then was able to replicate the same issue...put us on hold for some time and came back with a workaround solution. But the workaround didn't work for us. So just to recap our problem...we create a new form in the Groups area, then go to OneDrive and all we see is a generic spreadsheet titled "Untiltled form.xlsx" that contains no data.
The fix she said is to go to the ellipsis within the Response tab and click the Sync option...but the problem is, we don't have the 4th menu item titled "Sync".
So now we are waiting for them to research why it is we don't have the Sync option. I told her I think it might be related to the fact that when we create an Excel spreadsheet inside the OneDrive group we don't see Insert | Survey … but when I create an Excel spreadsheet from my OneDrive (non group) I see the Insert | Survey icon. I think that is where it gets disconnected. She didn't really think that was the issue, so we will see.
Hi es_en
I'm not really sure what's going on but would be interested to learn the answer when you have one.
In the meantime have a terrific weekend ahead!
Cheers
Damien
