Unanswered

Count number of matching answers from MS forms

(0) Share

Report

Posted on by smag

Hey,

I have a MS forms, which delivers about 100 questions per response. Most of them can be answered as "Ok" or "Not ok", defined by a multiple choice.

In my flow, I create a word document out of the answers of Forms and this document will be sent by mail. I want to show in the mail message the amount of given "Not Ok" answers.

Is there a way to count this, for example in a loop, instead of having 100 "if answer = "not ok", add 1"...?

BR,

smag

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sundeep_Malik 6,484 on at

Like (0)

Report

Hey @smag

You can do the following:

Create an integer variable, initialize it with -1:

Then create a string variable. Initialize it with body coming from get response details:

After this use a compose action and split it on Not Ok with the following expression:

(Replace ABV with the name of your variable)

split(variables('ABV'),'Not Ok')

After this use apply to each and add the output of that compose in it.

And use increment variable action in it and increment it by one.

After the apply to each you can use a compose action and add the count variable in it.

This will calculate all the not ok responses for you. I have given -1 in the integer

variable because split will give an extra count so automatically at the end you will

get the correct count by using -1 in the starting.

Output:

My Form:

Result in Flow:

I hope this helps 🙂

Was this reply helpful? Yes No
smag 31 on at

Like (0)

Report

Hey,
I testes this one:

But I get this result:

What do I have to change?

BR,
smag

Was this reply helpful? Yes No
Verified answer

Sundeep_Malik 6,484 on at

Like (0)

Report

Hey @smag

You have to write it under expressions like this:

At the end it would look like this:

Was this reply helpful? Yes No