Hi all, I am creating a Power Automate that collects Form responses and stores them in SPO, nice and easy so far 🙂
The questions can either have an answer of agree or disagree. If you answer agree this equals 1 point.
I have a table to grade a score based on the below.
Looking at the table if someone answers agree to question 2 then this is 1 point. Each column of numbers relates to a question. I need to capture how many times someone answers agree to the question and to total this for each column.
I think this will be a IF statement with an array where the numbers are stored but I am unsure where to start.
User | Count |
---|---|
92 | |
46 | |
21 | |
19 | |
17 |
User | Count |
---|---|
144 | |
51 | |
42 | |
40 | |
31 |