Forum Discussion

emilycs94's avatar
emilycs94
Copper Contributor
Aug 02, 2023

Can this be automatically scored?

Hello,   I would like to know if it’s possible to have automated scoring for the following type of form (questionnaire) with 5 options for each question    eg “very much” (4), “quite a lot” (3), ...
microsoft forms
Survey
Rob_Elliott's avatar
Rob_Elliott
Silver Contributor
Aug 03, 2023

emilycs94 there's no way to that with just Forms. Normally I look to do something like this with a flow in Power Automate that triggers each time a Forms response comes in, applies a score based on the answer to each question and adds the details and score to a SharePoint list. But with about 60 questions that would make the flow and list very big, it would take quite a long time to build and be more prone to error.

 

I think your simplest solution is to regularly copy the responses from the spreadsheet behind the form into a different spreadsheet that has the response to each question plus an additional column for each question that has an If formula e.g.

 

=IF(G6="very much",4, IF(G6="quite a lot",3, IF(G6="sometimes", 2, IF(G6="mildly", 1,0 ))))

 

Even there, the number of questions makes it quite a lengthy task.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

Resources