Forum Discussion
How to generate a lot of questions in Microsoft Forms
SHCNakamura you won't be able to create a form with more than 100 questions because Forms has a hard limit of 100 questions. And the actual limit might be far lower if you use likert questions because each statement is treated as a question.
There is no API for creating questions although there is one for getting the responses (although I always use Power Automate to save the responses to a SharePoint list). Excel can be used for populating the answers to choice questions but not for creating the questions themselves.
I don't know VBA but there is a link https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/reference-microsoft-forms which might be useful.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
SHCNakamura you won't be able to create a form with more than 100 questions because Forms has a hard limit of 100 questions. And the actual limit might be far lower if you use likert questions because each statement is treated as a question.
There is no API for creating questions although there is one for getting the responses (although I always use Power Automate to save the responses to a SharePoint list). Excel can be used for populating the answers to choice questions but not for creating the questions themselves.
I don't know VBA but there is a link https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/reference-microsoft-forms which might be useful.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
Thank you for your answer.
I'm sorry, but let me ask you another question.
Instead of creating 100 questions in one form, the challenge is to create more than 100 forms.
I've confirmed that I can output answer results to Excel,
but can I also use it to input answers?
I would appreciate it if you could tell me.
Best regards.
SHCNakamura you can only drag & drop answers from Excel into a choice question.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)- Unfortunately, I'll try to make it with drag&drop until the import function is added.
Thank you very much.
