Jan 11 2023
- last edited on
Aug 03 2023
I created a survey of 88 questions, the first 8 requiring text answers and the remaining 80 using the Likert answer structure (strongly agree, agree, neither agree nor disagree, disagree and strongly disagree). The survey was grouped into 6 specific sections.
During its compilation, and due to the number of questions included in the survey, a number of iterative changes were made by:
Responses to the survey were received from 29 organisations which were then downloaded to Excel for analysis.
A report has been generated and distributed to a consultative group of the 29 organisations for feedback
Jan 12 2023 02:46 AM
@Roger_Jameson I suspect the problem is related to the size of the form: there is a hard 100 question limit on a form, but each likert statement counts as a question. So it looks to me that you've breached the limit, not helped by the changes to questions. Particularly for large forms Forms is the most flakey of M365 apps. For the future I recommend you use a flow in Power Automate to save each response into a SharePoint list. Not only is this good practice for audit and backup reasons but if problems occur you are far less likely to get a problem with a SharePoint list than with the spreadsheet behind the form.
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)