Problem with Form collecting data

%3CLINGO-SUB%20id%3D%22lingo-sub-312341%22%20slang%3D%22en-US%22%3EProblem%20with%20Form%20collecting%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-312341%22%20slang%3D%22en-US%22%3E%3CP%3EI%20created%20an%20information-collection%20form%20last%20week%20and%20one%20user%20was%20able%20to%20use%20it%20successfully.%20Based%20on%20feedback%20from%20that%20user%2C%20I%20modified%20the%20form%20a%20little.%20Yesterday%2C%20another%20user%20submitted%20multiple%20responses%20using%20the%20form%2C%20and%20while%20I%20can%20see%20the%20responses%20in%20the%20form%20results%2C%20those%20results%20did%20not%20populate%20the%20associated%20Excel%20file%20at%20all.%20I%20tried%20opening%20the%20Excel%20file%20from%20the%20form%20itself%2C%20but%20the%20file%20just%20keeps%20Loading....%20I've%20waited%20over%2010%20minutes%20for%20it%20to%20open.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20for%20me%20to%20see%20or%20update%20the%20path%20to%20the%20associated%20Excel%20file%20from%20the%20form%20itself%3F%20I%20really%20don't%20want%20to%20have%20to%20completely%20rebuild%20the%20form%20just%20to%20fix%20the%20association.%20I%20also%20have%20a%20lot%20of%20data%20to%20retrieve%20from%20the%20second%20user%2C%20and%20retrieving%20it%20one%20page%20at%20a%20time%20will%20be%20tedious.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20it%20helps%2C%20the%20form%20is%20at%20%3CA%20href%3D%22https%3A%2F%2Fforms.office.com%2FPages%2FResponsePage.aspx%3Fid%3DnQyq5p424Ueaw9DczPC1kl9zcJhK1VVNn6OUEmXQGudUOEREWE9VTU83WURPVUU1MjlSUEozRklNSCQlQCN0PWcu%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fforms.office.com%2FPages%2FResponsePage.aspx%3Fid%3DnQyq5p424Ueaw9DczPC1kl9zcJhK1VVNn6OUEmXQGudUOEREWE9VTU83WURPVUU1MjlSUEozRklNSCQlQCN0PWcu%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-312341%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-313375%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Form%20collecting%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-313375%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F262454%22%20target%3D%22_blank%22%3E%40kweiss%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20personally%20haven't%20experienced%20the%20issue%20but%20I%20would%20recommend%20trying%20a%26nbsp%3Bcouple%20of%20things%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20Load%20for%20the%20Form%20results%20in%20different%20web%20browsers%20to%20see%20if%20that%20helps%20with%20downloading%20the%20Excel%20file.%3C%2FP%3E%3CP%3E2.%20Log%20a%20ticket%20with%20Microsoft%20Support%20to%20get%20them%20to%20send%20you%20the%20Form%20results%20if%20they%20can.%3C%2FP%3E%3CP%3E3.%20Recreate%20the%20form%20in%20Office365%20in%20SharePoint%2FOneDrive%20online%20by%20going%20to%20%3CSTRONG%3ENew%20%26gt%3B%20Forms%20for%20Excel%3C%2FSTRONG%3E.%20It%20would%20be%20worth%20it%20in%20the%20long%20run%20to%20get%20direct%20access%20to%20the%20Excel%20file%20results%20in%20real-time%20I%20would%20suggest.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20215px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F65805i14C8ED12462B015A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22capture20190111100148550.png%22%20title%3D%22capture20190111100148550.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20wishes%20with%20your%20Form!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-312354%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Form%20collecting%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-312354%22%20slang%3D%22en-US%22%3EHi%20Kweiss%2C%3CBR%20%2F%3E%3CBR%20%2F%3EAFAIK%2C%20there%20is%20no%20way%20to%20see%20or%20update%20the%20path%20of%20the%20associated%20file%20if%20you%20have%20created%20the%20Form%20online%20in%20Microsoft%20Forms.%20There%20are%20known%20issues%20when%20doing%20it%20online.%20See%20the%20Uservoice%20here%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fmicrosoftforms.uservoice.com%2Fforums%2F386451-welcome-to-microsoft-forms-suggestion-box%2Fsuggestions%2F35626120-fix-excel-online-integration%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmicrosoftforms.uservoice.com%2Fforums%2F386451-welcome-to-microsoft-forms-suggestion-box%2Fsuggestions%2F35626120-fix-excel-online-integration%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EPersonally%2C%20I%20would%20recommend%20to%20recreate%20the%20form%2C%20but%20to%20do%20so%20through%20SharePoint%2C%20OneDrive%20in%20Teams%20because%20you%20will%20be%20able%20to%20easily%20access%20the%20excel%20which%20has%20a%20live%20data%20connection%20to%20the%20form%2C%20as%20well%20as%20resync%20the%20data.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fhow-to-get-missing-data-in-forms-9fb98299-4dcc-41a4-bb29-34a9c3daf8cc%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fhow-to-get-missing-data-in-forms-9fb98299-4dcc-41a4-bb29-34a9c3daf8cc%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EThis%20should%20give%20you%20a%20better%20experience.%3CBR%20%2F%3E%3CBR%20%2F%3EHope%20this%20helps%20and%20that%20I%20have%20answered%20your%20question.%3CBR%20%2F%3E%3CBR%20%2F%3EBest%2C%20Chris%3C%2FLINGO-BODY%3E
Occasional Visitor

I created an information-collection form last week and one user was able to use it successfully. Based on feedback from that user, I modified the form a little. Yesterday, another user submitted multiple responses using the form, and while I can see the responses in the form results, those results did not populate the associated Excel file at all. I tried opening the Excel file from the form itself, but the file just keeps Loading.... I've waited over 10 minutes for it to open.

 

Is there a way for me to see or update the path to the associated Excel file from the form itself? I really don't want to have to completely rebuild the form just to fix the association. I also have a lot of data to retrieve from the second user, and retrieving it one page at a time will be tedious.

 

If it helps, the form is at https://forms.office.com/Pages/ResponsePage.aspx?id=nQyq5p424Ueaw9DczPC1kl9zcJhK1VVNn6OUEmXQGudUOERE...

2 Replies
Hi Kweiss,

AFAIK, there is no way to see or update the path of the associated file if you have created the Form online in Microsoft Forms. There are known issues when doing it online. See the Uservoice here:

https://microsoftforms.uservoice.com/forums/386451-welcome-to-microsoft-forms-suggestion-box/suggest...

Personally, I would recommend to recreate the form, but to do so through SharePoint, OneDrive in Teams because you will be able to easily access the excel which has a live data connection to the form, as well as resync the data.

https://support.office.com/en-us/article/how-to-get-missing-data-in-forms-9fb98299-4dcc-41a4-bb29-34...

This should give you a better experience.

Hope this helps and that I have answered your question.

Best, Chris

Hi @kweiss

 

I personally haven't experienced the issue but I would recommend trying a couple of things:

 

1. Load for the Form results in different web browsers to see if that helps with downloading the Excel file.

2. Log a ticket with Microsoft Support to get them to send you the Form results if they can.

3. Recreate the form in Office365 in SharePoint/OneDrive online by going to New > Forms for Excel. It would be worth it in the long run to get direct access to the Excel file results in real-time I would suggest.

 

capture20190111100148550.png

 

Best wishes with your Form!

 

Cheers

Damien