Unanswered

Using Flows to divert specific form responses to different excel sheets in share point

(0) Share

Report

Posted on by Community Power Pla...

I have a single MS form collecting data from different users, now for every response , i want to link my MS form to multiple excel sheets on my sharepoint, so that for the individual response, it is sorted into the users based sheets automatically. How can i do it?

Categories:

Using flows

I have the same question (0)

All responses (8)

Answers (0)

ArchitectMadhan 1,584 on at

Like (2)

Report

Hi @Anonymous ,
Its simple, In your Microsoft Forms use a field called category. While reading the MS Forms response from Power Automate Flow, based on the Category field you can use Switch Action to redirect the Form response to go to right excel sheet.

In the below example I have used Job Tile instead of Category.
If you find my solution helpful for resolving the issue, then please consider giving thumbs up and Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
lorrizanne 4 on at

Like (0)

Report

This is exactly what I've been searching for. I was previously using the IF and FILTER functions but the 255 character limit was killing me. I also kept trying to use Advanced Filters, but it's not available in Excel Online and can't be automated without a macro. THANK YOU for this solution!

Was this reply helpful? Yes No
Kkkkkkmmm 4 on at

Like (0)

Report

I also have the same problem, but when i tried switch control, the response goes to a different excel file.

I want my response to go to different sheet instead, so i can view the responses in one excel file only

Was this reply helpful? Yes No
msrsdlkjucma 2 on at

Like (0)

Report

I did the exact same step from the photo you've shown, but it still goes to the same sheet instead of separating into a different sheet/tab. How can I choose a different sheet name so it can redirect to that specific sheet?

Was this reply helpful? Yes No
RobElliott 10,323 Super User 2025 Season 2 on at

Like (0)

Report

@msrsdlkjucma make sure you give each table in the different sheets a unique name and point the add a row into a table inside the switch to the correct table.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Was this reply helpful? Yes No
Kkkkkkmmm 4 on at

Like (0)

Report

I did. But the result is still the same. Still going to the original form sheet

Was this reply helpful? Yes No
swgsit 44 on at

Like (0)

Report

hi, is this solved??

Was this reply helpful? Yes No
CarolinaB 4 on at

Like (0)

Report

Hi! I have 16 categories, so 16 sheets. And each time I have to load the 11 answers to the form. I couldn't find a workaround using variables to make the creation of the flow less "manual" and to have it be more flexible if I ever create a 17th category. Do you have any ideas? Thanks!

Was this reply helpful? Yes No