cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ChrisHansen12
New Member

Form with Conditional Question to Specific Excel Table

Hey community,

I've been searching the forums and haven't found a question exactly like mine so I figured I would ask for some help.

 

I have created a Form using MS Forms and want to use MS Flow to add the questions to a row in an Excel spreadsheet.

 

I have two tables that I would like to add a row to and I would like it to be dependant on the 1st question on my form "Is this a laptop or a mobile phone?". If Laptop is selected, I would like to add it to the Laptop table in the spreadsheet and I would like it to add it to the Mobile table if mobile phone is selected.

 

However, attempting this myself and looking through tutorials online gets me close but no cigar. Below and I have my main issue, that my fields don't appear to be populating from my form. I've tried some Expressions that were on this forum but to no avail.

 

Below is my attempt at setting the conditional variable. But I'm only provided with these options. I feel like I'm missing a step somewhere.

help.png

 

Any advice would be very appreciated! And thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
RookieI
Resolver I
Resolver I

Question option needs to be obtained using Get response details action.

35.PNG

View solution in original post

2 REPLIES 2
RookieI
Resolver I
Resolver I

Question option needs to be obtained using Get response details action.

35.PNG

View solution in original post

This wasn't populating before when I had it. But it definitely is now.

 

So thank you!!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,523)