Power Automate Exchange

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

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

Original Message:
Sent: Nov 18, 2022 03:50 PM
From: Kelly Knecht
Subject: Add record to Excel with Branched Forms

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

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

Original Message:
Sent: Nov 18, 2022 03:50 PM
From: Kelly Knecht
Subject: Add record to Excel with Branched Forms

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

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

Original Message:
Sent: Nov 21, 2022 12:08 PM
From: Autumn Schuman
Subject: Add record to Excel with Branched Forms

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

Original Message:
Sent: Nov 18, 2022 03:50 PM
From: Kelly Knecht
Subject: Add record to Excel with Branched Forms

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

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

Original Message:
Sent: Nov 28, 2022 07:30 PM
From: Kelly Knecht
Subject: Add record to Excel with Branched Forms

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

Original Message:
Sent: Nov 21, 2022 12:08 PM
From: Autumn Schuman
Subject: Add record to Excel with Branched Forms

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

Original Message:
Sent: Nov 18, 2022 03:50 PM
From: Kelly Knecht
Subject: Add record to Excel with Branched Forms

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