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 Nov 18, 2022 03:50 PM
    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 Nov 21, 2022 03:41 AM
    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 Nov 21, 2022 12:09 PM
    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 Nov 28, 2022 07:30 PM
    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
    ------------------------------



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

    Bronze Contributor
    Posted 11 days ago
    Hi Kelly,
    When you go to My Flows, there are three groupings below the Flows header on that page, tabs if you will. Below are the three and what you can expect to find there. If you've shared any of your flows with other users, or added to the owners list (and that MIGHT include functional accounts, but I do not know off the top of my head), they'll be in bucket 3, Shared with me.
    1. Cloud flows (created by you, not shared with any other users / owners / ?functional accounts?)
    2. Desktop flows (Basically a launch button for Power Automate for Desktop, a similar but pretty different application that runs locally on your hardware and not in the cloud)
    3. Shared with me (flows having been shared WITH you, or BY you)
    ​Hope that helps with troubleshooting - it's gotten me several times since I'm not in Power Automate very often these days, and every time I jump in, there are layout and naming changes...

    ------------------------------
    Rob Clark
    Cambridge
    ------------------------------