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.
Helpful resources
Power Automate News & Announcements
Keep up to date with current events and community announcements in the Power Automate community.
Community Calls Conversations
A great place where you can stay up to date with community calls and interact with the speakers.
