Power Platform Community Forum Thread Details

Hi,

I'd like to assign a score to each answer to questions in a Microsoft Forms survey, and calculate the total score at the end of the survey.

E.g

Q1 - What is your grasp of Microsoft Power Automate?

I do not know how to use PA. (Score of 0)

I have used PA a little (Score of 1)

I have used PA a lot (Score of 2)

Etc etc.

There will be multiple questions and Id like to assign a score of 0-4 for each answer and then calculate the total score.

Can someone please assist me in doing this?

Thanks for your time.

Categories:

Building flows

Hi @AaronC2 ,

One way I have done this successfully is to use cases and variables. As an example, for each question, have a switch case and assign the value to the variable.

So to start, after get reponses, I would have a series of initialize variables Q1, Q2, Q3, Q4, etc, etc.

Next my first switch case would be for question 1, case 1 = I do not know how to use PA., case 2 = I have used PA a little, case 3 = I have used PA a lot, and maybe a default case (not really needed).

Then inside each case, you set the variable to a value. So if question 1 was "I do not know how ot use PA", your case 1 would be true and the value of the variable Q1 would be 1. Etc, etc.

Finally, you need the total points. You can do that the old fashion way with a compose and math, the additional add(), only accepts two variables at a time, so thing of nested variables, such as add(add(Q1,Q2),add(Q3,Q4)) for compose1, compose2 add(output(compose1),add(Q5,Q6)), compose3 add(output(compose2),add(Q7,Q8), etc, etc.

Goes without saying, there are other ways to do this, just typing as I am thinking...