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?

All responses (8)

Answers (0)

CarolinaB 4 on at

Like (0)

Report

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

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!
swgsit 42 on at

Like (0)

Report

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

hi, is this solved??
Kkkkkkmmm 4 on at

Like (0)

Report

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

I did. But the result is still the same. Still going to the original form sheet
RobElliott 10,118 Super User 2025 Season 1 on at

Like (0)

Report

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

@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.
msrsdlkjucma 2 on at

Like (0)

Report

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

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?
Kkkkkkmmm 4 on at

Like (0)

Report

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

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
lorrizanne 4 on at

Like (0)

Report

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

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!
ArchitectMadhan 1,580 on at

Like (2)

Report

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

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.