Skip to main content

Notifications

Power Automate - AI Builder
Suggested answer

Pulling Data from Branching Choice Option in Microsoft Forms and Putting Info in Excel

Like (1) ShareShare
ReportReport
Posted on 5 Oct 2024 18:52:42 by 2
I created a Microsoft Form that has branching options based on four training options and the quarters of the year.
 
The quarters of the year being January through March, April through June, July through September, and October through December.
 
If someone wants to do training during the first quarter, January through March, they cannot do any of the other training during that quarter. They are presented with a branching option to select a different quarter for the next set of training.
 
For example: User selects Q1 for training and gets presented with Q2, Q3, and Q4 for the next set of training. 
 
Because it is branching, there are different options presented based on the initial quarter selected. If they select Q3 as the first choice, they are then presented with Q1, Q2, and Q4. This branching continues until they are complete.
 
The problem I'm running into is, when the information posts in Excel, it only shows the first choice they selected, because it is the only one that only has one list of choices, and no branches. All the other choices are based on branches and that appears to be why they don't populate the fields.
 
Therefore, I'm trying to figure out how to look across the different options across the branches to pull the selected choice and place it in the Excel field. 
 
I was thinking it would be a "select" option with a key of the excel field and the value from the choice inputs, but I'm not exactly sure how to figure that out.
 
Any assistance on this would be greatly appreciated. I'm very new in the use of Power Automate, and I have been searching like crazy and watching a lot of YouTube videos trying to figure this out.
Categories:
  • CU07102108-1 Profile Picture
    CU07102108-1 2 on 07 Oct 2024 at 21:11:11
    Pulling Data from Branching Choice Option in Microsoft Forms and Putting Info in Excel
    Thanks FLMike for your response. Seems like I was able to figure it out. 
     
    It was actually pretty simple, because of the way I had the form set up, that all I needed to do was put all potential responses in the same field in my flow. The only information that would show up is the information that was selected.
     
    Cheers! And thanks again for jumping on the post.
    Charles
  • Suggested answer
    FLMike Profile Picture
    FLMike 29,371 on 06 Oct 2024 at 07:42:08
    Pulling Data from Branching Choice Option in Microsoft Forms and Putting Info in Excel
    HI,
     
    I am not sure I understand what you mean by it doesn't show up in the Excel.
     
    If its not there then the issue is in your flow. Kindly share your flow as there isn't a way to help you based on the information above.

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

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #9 Get Recognized…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,316

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,290

Leaderboard
Loading complete