Duplicate questions in microsoft forms answers downloaded in excel

snehlatagiri 

that's one of the problems with responses that are at least partially AI-generated which I suspect that one was : there is no "get question details" action in Power Automate. The way you can achieve what you want quite easily IS with a flow in Power Automate and it's not complicated, but depending on how many likerts you've got it might take a while to build.

One thing I have noticed is that if you duplicate a likert question and the statements in it, sometimes a flow can select the wrong answer even though you added it correctly in the flow. So my advice would be to go through and add each likert question and the statements and answers individually. I know that's a pain but I think there might be a bug somewhere with the duplication of likert questions.

Anyway the steps are as follows:

This is my the form which I'm about to submit and it has low medium and high for each of the 4  colours. 

Next, create a spreadsheet with a column for the responder's email then a column for each of the answers in the likerts. You'll see I've called them You - Green, Mother - Green, Father - Green etc. Make sure you format it as a table.

Next create an instant cloud flow from a blank flow. Do not use the Forms template in Power Automate as it has an error which Microsoft have never corrected.

Every flow has 1 trigger followed by actions. The trigger is the Forms when a new response is submitted" and you select your form from the dropdown.

The first action is "get response details". You again select your form then click in the Response Id field. The dynamic content box will appear at the bottom right of your screen and in this case the only thing you can select is Response Id.

We just need to add 1 more action which is the Excel add a row into a table. For the File field click the folder icon and navigate your way to where you've saved the spreadsheet and select it and then the table.

 After a few seconds the columns from the spreadsheet will be displayed and you click in each field and select the appropriate item from the dynamic content box. It's usually helpful to use the search box and enter Green or Mother or Father and then you select the question that's correct for the column in the spreadsheet. It's this bit which could be time-consuming if you've got lots of duplicate likerts as you need to be careful you are selecting the correct one. So I entered Mother then Father in the search box.

When a response is submitted the flow will run and will populate the table, as shown below.

I hope that helps. Do come back with any questions.

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP UK (and classic 1967 Morris Traveller driver)