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

%3CLINGO-SUB%20id%3D%22lingo-sub-1219628%22%20slang%3D%22en-US%22%3ESurvey%20data%20not%20pulling%20through%20from%20Microsoft%20Forms%20Pro%20survey%20into%20Excel%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1219628%22%20slang%3D%22en-US%22%3E%3CP%3EQuestion%209%20of%20my%20survey%20is%20mandatory.%26nbsp%3B%20When%20I%20exported%20the%20latest%20run%20of%20my%20survey%20results%20approximately%20100%20answers%20to%20question%209%20are%20not%20pulling%20through.%26nbsp%3B%20On%20either%20side%20of%20the%20approx%20missing%20100%20I%20have%201%20answer%20before%20(the%20missing%20answers)%20and%205%20after.%26nbsp%3B%20Responses%20to%20questions%20following%20question%209%20are%20pulling%20through%20but%20not%20question%209.%26nbsp%3B%20I%20have%20tested%20the%20survey%20by%20completing%20it%20myself%20and%20all%20my%20answers%20populated%20on%20the%20exported%20spreadsheet.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1219628%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1526353%22%20slang%3D%22en-US%22%3ERe%3A%20Survey%20data%20not%20pulling%20through%20from%20Microsoft%20Forms%20Pro%20survey%20into%20Excel%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1526353%22%20slang%3D%22en-US%22%3EIm%20facing%20exactly%20same%20issue%20with%20around%2010%2F40%20questions%20with%20no%20responses%20while%20all%20of%20the%20questions%20in%20my%20survey%20are%20mandatory%20and%20i%20had%20test%20run%20it%20my%20self%20as%20well.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1526389%22%20slang%3D%22en-US%22%3ERe%3A%20Survey%20data%20not%20pulling%20through%20from%20Microsoft%20Forms%20Pro%20survey%20into%20Excel%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1526389%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F730672%22%20target%3D%22_blank%22%3E%40asmawali92%3C%2FA%3E%26nbsp%3B%20Hi%2C%26nbsp%3B%20I%20reported%20the%20problem%20to%20our%20IT%20team%20but%20before%20someone%20got%20to%20it%20the%20problem%20was%20fixed.%26nbsp%3B%20Looks%20like%20it%20was%20a%20fault%20with%20Forms%20Pro%20and%20Microsoft%20did%20something%20which%20fixed%20it.%26nbsp%3B%20Haven't%20had%20the%20problem%20since.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPoppy10%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1527521%22%20slang%3D%22en-US%22%3ERE%3A%20Survey%20data%20not%20pulling%20through%20from%20Microsoft%20Forms%20Pro%20survey%20into%20Excel%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1527521%22%20slang%3D%22en-US%22%3EI%20am%20also%20experiencing%20this.%20We%20have%20required%20questions%20on%20a%20Survey%20(Forms%20Pro)%20and%20about%208%2F47%20responses%20so%20far%20have%20been%20submitted%20without%20the%20required%20fields%20completed.%20I%20have%20not%20been%20able%20to%20recreate%20this%20behavior%20and%20am%20at%20a%20loss%20as%20to%20why%20this%20happening.%20We%20do%20have%20branching%20rules%20built%20in%20that%20hide%20some%20required%20fields%20based%20on%20answers%20to%20other%20questions%2C%20but%20all%20tests%20and%20most%20responses%20since%20going%20live%20with%20the%20survey%20have%20produced%20the%20required%20results....just%20not%20sure%20why%20randomly%2C%20submitters%20are%20ale%20to%20complete%20without%20entering%20the%20fields%20that%20are%20shown%20to%20them.%20Any%20thoughts%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1528493%22%20slang%3D%22en-US%22%3ERE%3A%20Survey%20data%20not%20pulling%20through%20from%20Microsoft%20Forms%20Pro%20survey%20into%20Excel%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1528493%22%20slang%3D%22en-US%22%3E%3CP%3EI%20think%20there%20might%20be%20a%20technical%20fault%20with%20Forms%20Pro.%26nbsp%3B%20My%20survey%20is%20showing%201511%20responses%20but%20when%20I%20go%20into%20the%20responses%20section%20to%20export%20my%20results%20it%20is%20showing%201501%20responses.%26nbsp%3B%20The%20exported%20spreadsheet%20has%2010%20blank%20rows%20(missing%20responses%3F)%20and%20it%20is%20pulling%20through%202%20questions%20which%20don't%20exist%20(deleted%20before%20the%20survey%20was%20sent%20out).%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F731154%22%20target%3D%22_blank%22%3E%40DianeTaylor%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1589354%22%20slang%3D%22en-US%22%3ERE%3A%20Survey%20data%20not%20pulling%20through%20from%20Microsoft%20Forms%20Pro%20survey%20into%20Excel%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1589354%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F578270%22%20target%3D%22_blank%22%3E%40Poppy10%3C%2FA%3E%26nbsp%3BI%20just%20had%20this%20exact%20problem%20occur%20twice%20this%20week%20on%20two%20separate%20forms.%20Both%20had%20mandatory%20questions.%20Forms%20data%20snapshot%20shows%20that%20all%20users%20completed%20all%20questions%2C%20yet%20excel%20export%20of%20data%20has%20empty%20cells.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1610677%22%20slang%3D%22en-US%22%3ERE%3A%20Survey%20data%20not%20pulling%20through%20from%20Microsoft%20Forms%20Pro%20survey%20into%20Excel%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1610677%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F266021%22%20target%3D%22_blank%22%3E%40NachoMSFT%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20similar%20problem%20in%20that%20the%20excel%20export%20had%20missing%20data%20from%20just%20one%20question%20in%20form.%20Previous%20responses%20have%20been%20ok%20and%20all%20other%20questions%20are%20ok.%26nbsp%3B%20%26nbsp%3B%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1631052%22%20slang%3D%22en-US%22%3ERE%3A%20Survey%20data%20not%20pulling%20through%20from%20Microsoft%20Forms%20Pro%20survey%20into%20Excel%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1631052%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20also%20facing%20same%20issue%2C%20my%20form%20shows%20there%20are%20235%20responses%20but%20when%20I%20export%20I%20only%20get%20220%20responses.%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F578270%22%20target%3D%22_blank%22%3E%40Poppy10%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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.  

7 Replies
Highlighted
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.
Highlighted

@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

Highlighted
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?
Highlighted

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 

Highlighted

@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. 

Highlighted

@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.   ??

 

Highlighted

I am also facing same issue, my form shows there are 235 responses but when I export I only get 220 responses.@Poppy10