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 Thanks for your response. That is pretty much what I thought would need to be done. I was thinking a list in SP that contained each question with the appropriate weight. When the response was received, the Flow would check the list, get the weight, and update the response record which would have a hidden question that related to each real answer. Thanks again
