cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CecileR
Level: Power Up

Using specific answers in Forms as conditions in a flow

Hi,

I was hoping to use Flow in conjunction with Forms to process answers to a survey.

I'm trying to use a specific answer to a multiple choice question as a condition in a flow but I can't seem to make it work. I'm not sure if I'm just having issues finding the right values in the condition or if it is just not possible.

I basically thought the condition should be

"question 4"  is equal to "answer a"

but in the dynamic content I only seem to find the questions, not the answers and typing the actual answer in the value box only seems to trigger a flow failure.

Apologies if the answer is obvious, I'm a newbie and would appreciate any help.

 

Cécile

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Using specific answers in Forms as conditions in a flow

@CecileR:

 

It sounds as though you are not using a Get Response Details action after the trigger. 

 

After your When a New Response Trigger is Submitted trigger, you need to use a Get Response Details action.  Referencing any of the Forms response columns (they will show up in Dynamic properties from the Get Response Details action) will put you into a loop.  The loop is OK since there is only one response and it will only loop one time.

 

Please see my screen shot below for an example.

FormsResponse.jpg 

If this solves your problem, please mark your post as Solved.

 

Scott

 

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

Scott

View solution in original post

4 REPLIES 4
Super User
Super User

Re: Using specific answers in Forms as conditions in a flow

@CecileR:

 

It sounds as though you are not using a Get Response Details action after the trigger. 

 

After your When a New Response Trigger is Submitted trigger, you need to use a Get Response Details action.  Referencing any of the Forms response columns (they will show up in Dynamic properties from the Get Response Details action) will put you into a loop.  The loop is OK since there is only one response and it will only loop one time.

 

Please see my screen shot below for an example.

FormsResponse.jpg 

If this solves your problem, please mark your post as Solved.

 

Scott

 

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

Scott

View solution in original post

CecileR
Level: Power Up

Re: Using specific answers in Forms as conditions in a flow

Hi Scott, 

 

Sorry it took me such a long time to get back to you.

The Get Response Details did work straight away, although I'm not using the "initialise variable" step, as I was not sure how to set that up. What function does it serve?

Also, the flows still seem to fail every time I have the excel sheet open when a form is filled in, do you know if there is any way to stop that?

Thanks again!

 

Cecile

 

MahashankariPN
Level: Powered On

Re: I need to loop the output of get response details. How to do it?

i have form. which contains 15 questions. I need to dynamically pass those 15 questions and validate it with answers.

duyarra
Level: Power Up

Re: Using specific answers in Forms as conditions in a flow

Amazing, your solution allowed me to create a Flow with a Form that, depending on the answer, triggers up to three different emails. I had to use the answer to the question ="the exact text of the response". I tried to use the question Id first but didn't work.

 

This opens up a whole world of possibilities. Thanks for sharing.

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Speakers, submit your sessions now! Call for speakers ends Feb. 10!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,644)