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
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,120)