Counting responses of a certain type in Microsoft Forms

[BazMan]

Hi All, 

I have a form where the answers are mainly Yes or No. I have a simple flow that sends a message on teams whenever a forms response is submitted.  Is there a way to count how many answers were 'No' and include that number in the Teams message?

Thanks in advance

Barry

[amitprajapati]

Hi @BazMan You can use the parallel branching in Power Automate. Below is my suggested way:

1. Create a Flow on trigger of Submit Response of MS Flow and get the response:

2. Initialize the Array variable of type Array:

3. Add parallel branch to check if question has no response if question has no response then add string "yes" to array:

Step 4: compose a variable to store the length of array and length of array will be number of no you have received in form

length(variables('Is No present'))

I have summited the below response from MS Form:

Output:

Hope this help, do verify the answer.

[OzNick]

Hi,
I have a form with many multiple choice questions, (Peg 1 - Peg 50), each with Radio buttons Armoury and Home Storage.

Do I create a condition branch for each Question or add each question to the branches? 

In my Initialize Variable I have "is Armoury present", but I'm not sure about the next step.

Thanks for your help.