Split data into different sheets excel

[alan7lp]

Hello!

I created a survey using Forms where I have a flow that fills in the answers to a Excel file saved in SharePoint.

My question is, would it be possible that based on a selected option in one of the questions in Forms, the data fills different tables allocated in a corresponding tab within the same Excel file?

Question 1: Select A, B or C

If I select A, fill all the information to XL FILE Sheet A.

If I select B, fill all the information to SAME XL FILE but Sheet B.

And so on.

Please, let me know if this is possible.

Thanks in advance,

Alan.

[Mister_Shaik]

Hi @alan7lp 

If you have 3 different sheets, that means you already have 3 tables, 1 in each sheet, to store the data. 

Then why don't you write a switch statement to add data to a particular table, based on the selection of user? This would move the data to different sheets as you've wanted.

Above, I've used a sample flow and it works exactly as you wanted.

Hope you find this helpful 🙂

Kind Regards,

Shaik Sha
________________________________________________________________________

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

[alan7lp]

Hi @Mister_Shaik !

That would work wonders. I am just quite new to Power Automate though. Would you mind show me how to create the part of the flow for the switch statement, please ?

My current flow looks like this:

I guess the switch function might go there where I marked it? In any case, if you don't mind to explain me more on that I will truly appreciate it 🙂

Thank yoU!

[Mister_Shaik · Accepted solution]

Yes, you absolutely can. Once you click on the section you just highlighted, you can click add new action and add the switch action.

1. Add a new action 

2. Add the switch statement

3. Add the On data from the output of the question which selects the sheet

4. Use the Case Equals to match the answer for question and what table to add data into, based on choice match

Kind Regards,

Shaik Sha
________________________________________________________________________

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

[alan7lp]

Great!

It works perfectly 🙂

Thanks for the support Mister!

Have a nice day !