Answered

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

(1) Share

Report

Posted on by 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

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
Blqnk39 30 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Verified answer

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No