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), “sometimes” (2), “mildly” (1), “not at all” (0)

 

if not, can anyone suggest a more straight forward way of me scoring these questionnaires as they have about 60 questions! 

thank you 😊 

microsoft forms
Survey
  • Rob_Elliott's avatar
    Rob_Elliott
    Bronze 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