Form Missing Data Responses due to Manual data entries in Excel File

%3CLINGO-SUB%20id%3D%22lingo-sub-1256201%22%20slang%3D%22en-US%22%3EForm%20Missing%20Data%20Responses%20due%20to%20Manual%20data%20entries%20in%20Excel%20File%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1256201%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20a%20Microsoft%20Form%20from%20an%20Excel%20Online%20worksheet%20stored%20on%20a%20OneDrive%20for%20Business%20location%20(ie%20folder%20within%20MS%20Teams%20Channel).%20Unfortunately%2C%20some%20began%20entering%20data%20direct%20in%20the%20Excel%20file%20or%20entered%20data%20in%20bulk%20or%20created%20empty%20rows%20and%20there%20is%20a%20consistency%20issue%20of%20what%20the%20Microsoft%20Form%20%22Responses%22%20page%20states%20vs%20the%20file%20stored%20on%20OneDrive%20excel%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20managed%20to%20incorporate%20the%20Rows%20and%20entries%20to%20within%20the%20Table%20(see%20the%20formatting%20expanded%20to%20my%20dataset)%2C%20but%20I%20struggle%20reinstating%20the%20linkage.%20Leadership%20is%20viewing%20the%20form%20and%20concerned%2C%20but%20it's%20under%20reporting%20critical%20safety%20data.%20The%20FORM%20is%20widely%20used%20and%20keen%20to%20retain%20the%20published%20Forms%20URL%20as%20we%20collect%20this%20data.%20This%20preparedness%20data%20to%20deal%20with%20Covid-19%20for%20our%20remote%20workforce.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1256201%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

I have created a Microsoft Form from an Excel Online worksheet stored on a OneDrive for Business location (ie folder within MS Teams Channel). Unfortunately, some began entering data direct in the Excel file or entered data in bulk or created empty rows and there is a consistency issue of what the Microsoft Form "Responses" page states vs the file stored on OneDrive excel file.

 

I've managed to incorporate the Rows and entries to within the Table (see the formatting expanded to my dataset), but I struggle reinstating the linkage. Leadership is viewing the form and concerned, but it's under reporting critical safety data. The FORM is widely used and keen to retain the published Forms URL as we collect this data. This preparedness data to deal with Covid-19 for our remote workforce.

0 Replies