Forum Discussion
Forms questions out of order when viewing results in Excel
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...
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.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
RobElliott Thanks Rob
