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
October Events

Mark Your Calendars

So many events happening this month - don't miss out!

 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (5,121)