Power Platform Community Forum Thread Details

I have one Microsoft Form with 10 questions. Question #3 asks what group they are in. Right now, ALL Form results are going to one master Excel Worksheet (500 responses)

Instead of one Worksheet displaying data for ALL groups, I want each group automatically populating in their separate group Worksheets when the form is filled out. So, for my 10 groups, I want 10 worksheets with about 50 responses in each.

If a student selects "ASL", I want their form responses to go to the "ASL" Worksheet/tab. If they select "NUR", I want those Form results to go directly to the "NUR" Worksheet tab.

Thanks in advance!

Categories:

AI Builder

When designing the same through cloud flow, sheets does not play a role here much as tables are used for adding data to excel files.

So within the same sheet having group name, we have to make the bot/user create the table with same name as group.

I have created which even creates the sheet with group name and along with creating table with group name if it does not exists when form is submitted.

See below

Here i need to answer 2 questions in form after selecting group

1. Use trigger and action to get responses from form when response is submitted.

2. Get list of all tables present in excel file

3. Use filter array to check whether any table with name of group is created in the excel

4. Use condition to check whether there is any table with group as part of output from filter array

if the condition is true- it means no such table with group name exists and flow need to create one, so in yes branch follow these steps

a. use create worksheet to create the worksheet with group name

Now create an empty table with same group name in the created sheet

Now add the row to created table

if condition is false, then bot should try these steps

1. It should add the row in table as shown below

Hope it helps !

Thanks & Regards,
Nived N
LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs
Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you!