Power Automate Exchange

Please login or click SIGN UP FOR FREE to create your FlowUG account to join this user group.
 View Only
  • 1.  Add record to Excel with Branched Forms

    Posted 19 days ago
    Hi PA Community,

    I've successfully created a form with branching. There are three potential paths (Software Update, Maintenance, Print Error).

    Each branch has a series of options or a text box for the response.

    When I create the flow to add a record to SharePoint Excel, only the branch title an option appears in Dynamic Content.
    In other forms when I select the question title, the question response populates in excel.
    However when I select the question title, the actual response to the question is not appending to excel.
    Actually, nothing but submission date, e-mail and a text field for the machine name appears on the excel.

    Is there a trick to getting to the branch level responses and adding them to an excel record?
    Or do I need to create three forms - one for Software Update, one for Maintenance, and one for Print Error)?


    ------------------------------
    Thank you
    Kelly
    ASCI
    ------------------------------


  • 2.  RE: Add record to Excel with Branched Forms

    Posted 17 days ago
    Hi Kelly,
    Build the form in Forms for Excel, not Forms, and you don't need to build a PowerAutomate, it does it for you.
    Guy

    ------------------------------
    Guy Boswell
    Care for the Family
    Newport
    02920810800
    ------------------------------



  • 3.  RE: Add record to Excel with Branched Forms

    Bronze Contributor
    Posted 16 days ago
    If I understand you correctly, I think you just need to add an action to 'Get Response Details' to get all of the dynamic content you're looking for. I believe that'll trick it into doing what you want!

    ------------------------------
    Autumn Schuman
    Power Platform Solutions Specialist
    Coralville IA
    319-830-0636
    ------------------------------



  • 4.  RE: Add record to Excel with Branched Forms

    Posted 9 days ago
    Hi Everyone,

    Thank you for your help. Through the responses I was able to discern the issue and solve the problem. I saved the flow and in the last 10 minutes have had multiple tests return the desired results.

    However, now my flow is missing. Actually all the flows I've created in the last 3 weeks are no longer listed in my flow list.

    Is this normal? Is there something I need to do? The test flow literally disappeared between testing and getting a cup of coffee. It was in my list a few minutes ago.

    Thanks
    Kelly

    ------------------------------
    Kelly Knecht
    98012
    Bothell
    ------------------------------