cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Blqnk39
Frequent Visitor

Is there a way to insert a row into different tables based on form responses?

Hi all,

 

Just out of curiosity, is there a way for us to insert new row into different tables in excel file based on the responses we receive from Ms Forms?

 

For example, response #1 orders Product A whereas response #2 orders Product B. Based on these responses, is there a way to insert these two new orders into Product A table and Product B table?

 

Thanks,

Blqnk39

1 ACCEPTED SOLUTION

Accepted Solutions

@Blqnk39  In Such cases use switch action if you have more choices..

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

View solution in original post

3 REPLIES 3
Hardesh15
Super User
Super User

@Blqnk39 Yes you can do this. In your flow use condition and then if condition match add data in your excel sheet table.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Hi Hardesh,

 

This suggestion above works for let's say two products (Product A and B).

 

What if I have more than 2, from Product A to E, does that mean I have to use condition and branch out into a big big flow?

@Blqnk39  In Such cases use switch action if you have more choices..

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (4,996)