Skip to main content

Notifications

Announcements

Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id : KC4J74e/3HqQT5LHnZpgRe
Power Platform Community / Forums / Power Automate - General Discussion / Using specific answers...
Power Automate - General Discussion
Answered

Using specific answers in Forms as conditions in a flow

Like (1) ShareShare
ReportReport
Posted on 10 Dec 2018 15:22:57 by CecileR 9

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

  • Saurabh_Jain Profile Picture
    Saurabh_Jain 4 on 25 May 2022 at 12:29:56
    Re: Using specific answers in Forms as conditions in a flow

    Dear Scott, Thanks its looks a good solution.

    I was trying to apply for a if condition 

    Ie. I have created a forms for Material Purchase Request..

    If the total value is more than 5 Million it should go to one person other wise to another person.

    But I am not able to put the value from Forms in condition.

    Request your help in here.

  • ANCC Profile Picture
    ANCC 23 on 22 Jan 2021 at 14:16:50
    Re: Using specific answers in Forms as conditions in a flow

    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 

  • ScottShearer Profile Picture
    ScottShearer 25,212 Most Valuable Professional on 08 Jul 2020 at 20:35:04
    Re: Using specific answers in Forms as conditions in a flow

    @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.

     

     

  • erjone Profile Picture
    erjone Microsoft Employee on 08 Jul 2020 at 20:03:06
    Re: Using specific answers in Forms as conditions in a flow

    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?

     

  • duyarra Profile Picture
    duyarra 5 on 19 Nov 2019 at 18:46:54
    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.

  • MahashankariPN Profile Picture
    MahashankariPN 6 on 26 Sep 2019 at 08:36:29
    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.

  • CecileR Profile Picture
    CecileR 9 on 08 Jan 2019 at 16:13:32
    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

     

  • Verified answer
    ScottShearer Profile Picture
    ScottShearer 25,212 Most Valuable Professional on 10 Dec 2018 at 19:50:38
    Re: Using specific answers in Forms as conditions in a flow

     

    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

     

    @CecileR:

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,668 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,004 Most Valuable Professional

Leaderboard

Featured topics

How to Ask for Help with Your Power Automate Workflow

Product updates

Microsoft Power Platform Community release plans