Forum Discussion

Copper Contributor

Mar 10, 2020

Survey data not pulling through from Microsoft Forms Pro survey into Excel spreadsheet

Question 9 of my survey is mandatory. When I exported the latest run of my survey results approximately 100 answers to question 9 are not pulling through. On either side of the approx missing 100 I...

microsoft forms

DianeTaylor

Copper Contributor

Jul 16, 2020

I am also experiencing this. We have required questions on a Survey (Forms Pro) and about 8/47 responses so far have been submitted without the required fields completed. I have not been able to recreate this behavior and am at a loss as to why this happening. We do have branching rules built in that hide some required fields based on answers to other questions, but all tests and most responses since going live with the survey have produced the required results....just not sure why randomly, submitters are ale to complete without entering the fields that are shown to them. Any thoughts?

Poppy10

Copper Contributor

Jul 17, 2020

I think there might be a technical fault with Forms Pro. My survey is showing 1511 responses but when I go into the responses section to export my results it is showing 1501 responses. The exported spreadsheet has 10 blank rows (missing responses?) and it is pulling through 2 questions which don't exist (deleted before the survey was sent out). DianeTaylor

Tinker_Bell
Copper Contributor
Oct 06, 2020
Same as Poppy10 only the missing just are not there. It starts on row 1 at ID 1960 instead of ID 1.
Vaibhav Antriwale
Copper Contributor
Sep 03, 2020
I am also facing same issue, my form shows there are 235 responses but when I export I only get 220 responses.Poppy10
- Tinker_Bell
  Copper Contributor
  Oct 06, 2020
  Vaibhav Antriwale Is there no sign of a fix yet from nikita
  - Vaibhav Antriwale
    Copper Contributor
    Oct 07, 2020
    Tinker_Bell Yeah, that's true. No resolution yet for this issue.
NachoMSFT
Former Employee
Aug 14, 2020
Poppy10 I just had this exact problem occur twice this week on two separate forms. Both had mandatory questions. Forms data snapshot shows that all users completed all questions, yet excel export of data has empty cells.
- Maggie645
  Copper Contributor
  Aug 25, 2020
  NachoMSFT
  I have a similar problem in that the excel export had missing data from just one question in form. Previous responses have been ok and all other questions are ok. ??