power automate

Question

How can I organize my students responses on the Microsoft forms by using the power automate?

Answer 1

Post/ask on the Power platform:

Explore Power Platform forums

Answer 2

To organize student responses from Microsoft Forms using Power Automate, create a flow that automatically writes each new response into an Excel table where responses can be sorted, filtered, and analyzed.

Steps to set this up:

1. Prepare the Excel file
   1. In Excel Online, create a new workbook.
   2. On a worksheet, create a table with one column for each question on the form (for example: Name, Class, Score, Feedback).
   3. Format the range as a table (Home → Format as Table) and save the workbook to OneDrive or SharePoint so Power Automate can access it.
2. Create the automated flow
   1. Go to Microsoft Power Automate and select Create → Automated cloud flow.
   2. Give the flow a name (for example, “Forms responses to Excel”).
   3. Under Choose your flow’s trigger, search for Microsoft Forms and select When a new response is submitted.
   4. In Form Id, choose the student form that collects the responses.
3. Get the full response details
   1. Select New step.
   2. Search for Microsoft Forms and choose Get response details.
   3. Select the same form in Form Id.
   4. In Response Id, choose Response Id from dynamic content.
4. Add the response to Excel
   1. Select New step.
   2. Search for Excel Online (Business) and select Add a row into a table.
   3. Set Location to where the workbook is stored (OneDrive or SharePoint) and choose the Document Library.
   4. Use the folder icon to browse to the workbook and select the table created earlier.
   5. For each column in the table, map the corresponding answer from Get response details using dynamic content (for example, map the “Student Name” question to the Name column, “Class” to Class, etc.).
   6. Save the flow.
5. Test and use the organized data
   1. Submit a test response to the form.
   2. In Power Automate, check the flow run history to confirm it succeeded.
   3. Open the Excel file and verify that a new row was added with the student’s answers.

Once this is in place, every new student response will appear as a new row in the Excel table. The teacher can then sort by name, class, date, score, or any other column, and use filters, charts, or formulas to organize and analyze the responses.

For more advanced organization, additional steps can be added to the flow, such as conditions to send different emails based on answers, or separate tables/sheets for different classes, using the same pattern of When a new response is submitted → Get response details → actions like Add a row into a table or Condition.

---

References:

• Setting Up an Automated Workflow Between Microsoft Forms and Excel Through Power Automate
• Common ways to use a form in a flow
• Create an automated workflow for Microsoft Forms