100 question Limit

%3CLINGO-SUB%20id%3D%22lingo-sub-309802%22%20slang%3D%22en-US%22%3E100%20question%20Limit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-309802%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20been%20working%20on%20a%20Microsoft%20form%20to%20act%20as%20a%20handover%20sheet%20internally%2C%20I%20have%20over%20200%20questions%20I%20need%20to%20put%20on%20it%20and%20once%20I%20reached%20100%20realised%20there%20was%20a%20limit.%20Is%20there%20anyway%20round%20this%20or%20another%20Microsoft%20product%20that%20might%20work%20better%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20in%20advance%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-309802%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-313382%22%20slang%3D%22en-US%22%3ERe%3A%20100%20question%20Limit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-313382%22%20slang%3D%22en-US%22%3EHi!%3CBR%20%2F%3E%3CBR%20%2F%3EOr%20you%20could%20just%20use%20SurveyMonkey%20and%20Integrate%20it%20with%20Microsoft%20Teams%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.surveymonkey.com%2Fmp%2Fmicrosoft-integrations%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.surveymonkey.com%2Fmp%2Fmicrosoft-integrations%2F%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3ESurveyMonkey%20has%20a%20limit%20of%205000%20questions%20per%20survey%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fhelp.surveymonkey.com%2Farticles%2Fen_US%2Fkb%2FAre-there-limits-in-SurveyMonkey-such-as-survey-design-or-character-limits%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fhelp.surveymonkey.com%2Farticles%2Fen_US%2Fkb%2FAre-there-limits-in-SurveyMonkey-such-as-survey-design-or-character-limits%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EBest%2C%20Chris%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-313380%22%20slang%3D%22en-US%22%3ERe%3A%20100%20question%20Limit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-313380%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%2F261332%22%20target%3D%22_blank%22%3E%40amyalice07%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20addition%20to%20the%20above%20suggestions%2C%20you%20could%20also%20try%20splitting%20the%20questions%20across%20two%20forms%2C%20and%20linking%20the%20two%20forms%20together%20in%20Microsoft%20Forms%20by%20providing%20a%20URL%20to%20form%20two%20in%20the%20%3CEM%3Ecustomised%20message%3C%2FEM%3Ewhen%20they%20finish%20form%20one.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20could%20be%20something%20like%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20have%26nbsp%3Bcompleted%20part%20one%20of%20the%20form.%20When%20ready%20please%20click%20the%20link%20below%20to%20begin%20part%20two.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fwww.yourlink.com%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.yourlink.com%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20side%20benefit%20to%20this%20workaround%20is%20that%20200%20questions%20is%20a%20lot%20to%20do%20so%20breaking%20up%20the%20form%20gives%20the%20responder%20a%20bit%20of%20a%20breather%20(in%20my%20opinion).%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%3CP%3EP.S.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869%22%20target%3D%22_blank%22%3E%40Chris%20Webb%3C%2FA%3E%2C%20congrats%20on%20your%20MVP!%20Well%20deserved!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-309942%22%20slang%3D%22en-US%22%3ERe%3A%20100%20question%20Limit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-309942%22%20slang%3D%22en-US%22%3E2nd%20what%20Allen%20said%2C%20depending%20if%20you%20have%20an%20external%20need%20or%20not%2C%20Forms%20might%20be%20your%20only%20option.%20%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20it%20is%20internal%20then%20you%20have%20PowerApps%20as%20Allen%20pointed%20out%2C%20or%20you%20can%20just%20use%20SharePoint%20list%20as%20well%20but%20keep%20in%20mind%20the%20limits%20around%20column%20maximums.%20This%20would%20also%20pertain%20to%20a%20PowerApp%20being%20backed%20by%20a%20SharePoint%20list.%20%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2FSharePoint%2Finstall%2Fsoftware-boundaries-and-limits%23Column%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2FSharePoint%2Finstall%2Fsoftware-boundaries-and-limits%23Column%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-309867%22%20slang%3D%22en-US%22%3ERe%3A%20100%20question%20Limit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-309867%22%20slang%3D%22en-US%22%3EYou%20will%20need%20to%20use%20a%20PowerApp%20instead%20and%20store%20the%20data%20in%20a%20SharePoint%20list%2C%20common%20data%20model%20if%20you%20all%20have%20P1%20licences%20or%20a%20SQL%20Azure%20database.%20You%20can%20create%20different%20screens%20in%20the%20PowerApp%20to%20split%20up%20the%20form%20or%20use%20grouping%20to%20hide%20and%20show%20sections%20of%20the%20form.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-309824%22%20slang%3D%22en-US%22%3ERe%3A%20100%20question%20Limit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-309824%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20are%20right%20about%20this%20limit%2C%20it's%20not%20documented%20very%20well%20but%20can't%20be%20overridden%20as%20I%20understand%20it.%26nbsp%3B%20You'd%20have%20to%20split%20the%20form%20into%20two%20parts%20for%20example%2C%20it%26nbsp%3Bwould%20be%20worth%20adding%20your%20support%20to%20increase%20this%20limit%20in%20Microsoft%20Forms%20Suggestion%20Box%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fmicrosoftforms.uservoice.com%2Fforums%2F386451-welcome-to-microsoft-forms-suggestion-box%2Fsuggestions%2F20316835-increase-the-limit-to-add-questions-in-a-form%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Eincrease%20the%20limit%20to%20add%20questions%20in%20a%20form%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I've been working on a Microsoft form to act as a handover sheet internally, I have over 200 questions I need to put on it and once I reached 100 realised there was a limit. Is there anyway round this or another Microsoft product that might work better? 

 

Thank in advance 

5 Replies

You are right about this limit, it's not documented very well but can't be overridden as I understand it.  You'd have to split the form into two parts for example, it would be worth adding your support to increase this limit in Microsoft Forms Suggestion Box:

 

increase the limit to add questions in a form

You will need to use a PowerApp instead and store the data in a SharePoint list, common data model if you all have P1 licences or a SQL Azure database. You can create different screens in the PowerApp to split up the form or use grouping to hide and show sections of the form.
2nd what Allen said, depending if you have an external need or not, Forms might be your only option.

If it is internal then you have PowerApps as Allen pointed out, or you can just use SharePoint list as well but keep in mind the limits around column maximums. This would also pertain to a PowerApp being backed by a SharePoint list.
https://docs.microsoft.com/en-us/SharePoint/install/software-boundaries-and-limits#Column

Hi @amyalice07

 

In addition to the above suggestions, you could also try splitting the questions across two forms, and linking the two forms together in Microsoft Forms by providing a URL to form two in the customised message when they finish form one.

 

It could be something like:

 

You have completed part one of the form. When ready please click the link below to begin part two.

http://www.yourlink.com

 

The side benefit to this workaround is that 200 questions is a lot to do so breaking up the form gives the responder a bit of a breather (in my opinion).

 

Best wishes with your Form!

 

Cheers

Damien

 

P.S. @Chris Webb, congrats on your MVP! Well deserved!

Hi!

Or you could just use SurveyMonkey and Integrate it with Microsoft Teams

https://www.surveymonkey.com/mp/microsoft-integrations/

SurveyMonkey has a limit of 5000 questions per survey

https://help.surveymonkey.com/articles/en_US/kb/Are-there-limits-in-SurveyMonkey-such-as-survey-desi...

Best, Chris