Forum Discussion

Poppy10's avatar
Poppy10
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 have 1 answer before (the missing answers) and 5 after.  Responses to questions following question 9 are pulling through but not question 9.  I have tested the survey by completing it myself and all my answers populated on the exported spreadsheet.  

  • asmawali92's avatar
    asmawali92
    Copper Contributor
    Im facing exactly same issue with around 10/40 questions with no responses while all of the questions in my survey are mandatory and i had test run it my self as well.
    • Poppy10's avatar
      Poppy10
      Copper Contributor

      asmawali92  Hi,  I reported the problem to our IT team but before someone got to it the problem was fixed.  Looks like it was a fault with Forms Pro and Microsoft did something which fixed it.  Haven't had the problem since.

       

      Poppy10

  • DianeTaylor's avatar
    DianeTaylor
    Copper Contributor
    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's avatar
      Poppy10
      Copper Contributor

      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 

      • NachoMSFT's avatar
        NachoMSFT
        Icon for Microsoft rankMicrosoft

        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. 

Resources