Can you save Forms responses into different Excel sheet in the same workbook based on multiple choice answer

(0) Share

Report

Posted on by Smetz

I have a Form that will be sent out to 100's of people across 10 properties. The first question is multiple choice where they select the property where they live. I would like to have all responses saved to a corresponding sheet in the same Excel workbook.

For example: A person selects "Property #3". Instead of one huge list of responses containing all properties to sort through, their submission will be sorted in a corresponding Sheet labeled Property #3

Is this possible?

All responses (1)

Answers (0)

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report

Re: Can you save Forms responses into different Excel sheet in the same workbook based on multiple choice answer

Hello @Smetz ,
I think you can use the "Switch" control in order to populate the right Table based on the answer received, like below:

I can read a simple overview upon the "Switch" control in this article:
https://blog.enterprisedna.co/power-automate-switch-control-action-in-workflows/

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
BR,
Marco