Forum Discussion
MS Forms Weighted
Hi Chris (Chris_Mancini) it's not possible with Forms on its own, but you could have a simple flow in Power Automate to save the weighting number (and any of the other answers in your form) to a different spreadsheet. The result is shown on the attached video.
The flow is shown below and triggers whenever a new form response is submitted. The first action is to get the response details, then we initialize a variable to hold the weighting score. Next, a type of condition called a Switch is added that looks at what the answer was in the question and then for each case applies the appropriate weighting to it and set the variable value. Finally it adds a row into a table in Excel using that variable value:
Come back with any questions about this.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
RobElliott I see you responded to this a while back. I am having some trouble with the weighted scores. I followed your instructions and did a weighted score for answers, for example, High Risk should equal 5, Medium Risk should equal 3 and so on. The information transfers to Excel from forms but it does not show the values, only the words like High Risk etc.
Not sure what to do at this point. I may be doing something wrong in the Switch section. I am using a Likert Scale question in Microsoft Forms.
Thanks in advance for your help!
alexelizondo RobElliott I have the same concern, only the value is shown on the spreadsheet, not the score.
