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

[Blqnk39]

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

[Hardesh15]

@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

[Blqnk39]

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?

[Hardesh15 · Accepted solution]

@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