Duplicate questions in microsoft forms answers downloaded in excel

snehlatagiri,

like i wrote before there is no built-in feature in Microsoft Forms or Excel that can do this automatically.

However, there is a workaround that you can try using Power Automate.

Here are the steps to create the Power Automate flow:

1. Go to the Power Automate website and sign in with your Microsoft account.
2. Click on Create and then select Flow.
3. Select the Automated from scratch option and then click on Create.
4. In the Trigger section, select When a new response is submitted and then select the Microsoft Forms form that you want to use.
5. In the Actions section, add the following actions:
   • Get response details
   • Get question details
   • Filter array
   • Create table
   • Add row to table
6. In the Get question details action, select the Question column from the Dynamic content list.
7. In the Filter array action, select the Question column from the Dynamic content list. In the Filter by section, select equals and then select the Question Text column from the Dynamic content list.
8. In the Create table action, select the Excel connector and then select the Create table action.
9. In the Add row to table action, select the Excel connector and then select the Add row to table action.

Configure the Create table and Add row to table actions to create a new table in Excel with the following columns:

• Question Heading
• Response

Add the following dynamic content to the Question Heading column:

item()['QuestionText']

Add the following dynamic content to the Response column:

item()['Value']

Save and run the Power Automate flow.

When a new response is submitted to the Microsoft Forms form, the Power Automate flow should be triggered and it will create a new Excel file with the question headings and responses.