Showing results for 
Search instead for 
Did you mean: 
Not applicable

IF statements and calculate a score

Hi all, I am creating a Power Automate that collects Form responses and stores them in SPO, nice and easy so far 🙂

Screenshot 2020-12-05 at 13.15.01.png

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.

Screenshot 2020-12-05 at 13.15.44.png

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.


Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,451)