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

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
ScottShearer
Super User III
Super User III

@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

7 REPLIES 7
ScottShearer
Super User III
Super User III

@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

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

 

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

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.

When I am doing something similar, I am unable to get the "List of response..." green like you have in the apply to each. Is there a way to get that option?

 

@erjone 

I'll need a little more information in order to assist.  I suggest you create a new topic and provide additional details along with a screen shot of your Flow as it currently exists.

 

 

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

Scott
ANCC
Frequent Visitor

I see this is old, but could you help me out to understand what the answer is. 

I think I am trying to achieve the same as you were:

Microsoft Form Questionnaire

Question 1: What's your favourite colour?
Choice 1 - Red

Choice 2 - Green

Choice 3 - Blue

 

Then when that form receives a response, if they respond Red, they would get an email relating to Red. If they respond Blue, an email about Blue....etc 

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (42,810)