Forum Discussion

Copper Contributor

May 01, 2023

Export Likert Question Text with Statements

Hi: I have a form with multiple likert questions that all have the same statements. (See example screen shot below - note this is not the actual form but just exemplarily). The problem is when...

microsoft forms

Survey

RobElliott

Silver Contributor

jennydkatz assuming you don't want to build a flow to save each response into a SharePoint list which would overcome your issue, the way I would do it is that for question 1 the statements would be

1A. Timeliness
1B. Length
1C. Content

Then the same for question 2:

2A. Timeliness

2B. Length

2C. Content

and so on.

If you do build a flow then this method of naming the statements will also help you identify the correct statement for saving into the SharePoint list or an Excel spreadsheet.

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

jennydkatz

Copper Contributor

May 02, 2023

Thank you RobElliott for the response! I appreciate the suggestion. Though - you are right - I would prefer not to have to build a flow/sharepoint list as the actual survey is a little bit more involved (6 likert questions with 10-18 statements each, etc.) And would prefer to keep it on the simple side. However, will toy around with your suggestion nonetheless and see how that goes.

Also, do you have a suggestion for how to get the question items in the right order at least?