Forum Discussion
Responses synced to SharePoint missing total points
Hi Jhallz
When I create a Quiz from within MS Forms, it gives the Total points column in the Excel spreadsheet.
I'm not quite sure what you mean by syncing to SharePoint Online unless you are using Forms for Excel when creating a new form from witnin a SharePoint Document Library (which does't give you the points options).
How are you creating your Forms?
Cheers
Damien
- Thanks Damien.
I created the quiz in Forms, then moved it under "Group forms" to my (currently private) communications site. Here the Excel syncs to the site's Documents library.
Excel only displays results for the Start and Completion time, Email, Name, and the questions. At the end, Grade posted time is empty in spite of posting grades for submissions. Nowhere does the spreadsheet display Total points or any other fields.
CheersHi Jhallz
I would suggest that if possible you try to create the Quiz in your Group itself rather than moving it, and see if that solves the issue.
In my experience, it would be better than moving things around.
Cheers
Damien
Hi Damien_Rosario, thank you for the suggestion.
I can create a new group quiz and see total points for it. However, the results do not sync to the SP site. It is strange this is not available, but is at least consistent with the notes in the https://support.office.com/en-us/article/troubleshoot-exporting-form-data-to-excel-bd82c176-8cd5-4d27-a13e-b15d4aac3a28.
Anyway, it's a step closer towards working with the results data.
Rgds!
