cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kypaco
New Member

Rooting Out Unanswered Questions in Flow Response

Hi there,

 

I am having difficulty in figuring out how to build my flow. I have an MS Form that is broken down into multiple sections and sometimes some of the sections do not get used due to the answers provided. My goal is to setup a Flow that only displays the answered questions rather than displaying every single question - answered or unanswered. 

 

Additionally, I would like to base the email destination based on the location the form is submitted from (this is one of the first questions in the form). I do understand I may need to make a specific form for each location to breakdown the email addresses properly.

 

Any assistance this community can provide is greatly appreciated! 

4 REPLIES 4
MarconettiMarco
Super User
Super User

Hello @kypaco ,

in regards of the first topic, please follow these steps:

1. Get response details:

MarconettiMarco_0-1660289128432.png

 

2. Initialize an Array variable in which put the following expression:

createArray(outputs('Get_response_details')?['body/r641f82783a80491495ac6ce714a0cfd8'],outputs('Get_response_details')?['body/ref24e6486aa24a05ac15e6313beb66b8'])

In my case I only have 2 questions, so in the expression you should add all the questions.

 

3. Add a "Filter array" action putting the following expression in advanced mode:

@equals(empty(item()), false)

MarconettiMarco_1-1660289265999.png

 

Here my outputs:

MarconettiMarco_2-1660289292768.png

 

If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

 

 

MarconettiMarco
Super User
Super User

Hello @kypaco ,

here the complete flow:

https://powerautomatejoy.com/2022/08/12/forms-how-to-get-only-answered-questions/

 

If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

Thank you for your response!

I seem to be a little stuck and am looking for some clarification. I was able to follow along pretty well up until the output portion of your message. 

kypaco_0-1660579880471.png

This is where I'm currently at. Where do I choose/set the outputs?

Hello @kypaco ,

please follow the steps present in this article:

 

https://powerautomatejoy.com/2022/08/12/forms-how-to-get-only-answered-questions/

 

Then, run the flow, and you’ll see the outputs in the last action “Filter array”.

this output can be used for the next actions.

 

If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,190)