Power Platform Community Forum Thread Details

Hello Community!

I am working on a project where I need to automate the process of sorting new responses from a Microsoft Form into different Excel workbooks based on a specific response (Eg: User Region). We have a single form that is used for 15 (And growing) different products, and each product has its own dedicated Excel workbook for data collection and sharing.

Here's the workflow I am trying to automate:

Form Submission: A User fills out the MS Form, selecting one of the 15+ products from a dropdown list.
Data Segregation: Based on the product selected, the form response (Corresponding Row in the spreadsheet) should be automatically added to the corresponding Excel workbook.
Workbook Management: Each product has its own Excel workbook, and I need to ensure that responses are directed to the correct workbook.

I did try building a couple of basic flows but I get stuck at the conditions part as right now it seems like the number of nested / parallel conditions would keep expanding and would over complicate the flow.

This is my current Manual process:

A user completes the form
I open the spreadsheet of the form, and I manually copy and paste entries based on their region to their respective individual Region's Workbooks files.
I share the new workbook file to the respective individual.

I am hoping to see if there is a way to automate this process

Thank you in advance for your help!

Categories:

Building flows