Home
Microsoft

Use the Likert, a new survey question type in Microsoft Forms

If you want to gauge your customers’ overall sentiment around a particular item or experience, you can create questions that capture responses on a scale. Also known as a Likert, you may, for example, create a question that asks students whether they agree with a statement or respondents to evaluate a product.

 

In Microsoft Forms, click on the "…" menu of the question bar to access Likert questions.

Likert.png

 

You can define scaling options as columns and question statements as rows.

likert design time.png

 

On mobile devices, Likert questions will be grouped together. You can auto collapse and expand each question.

Runtime - Mobile.png

 

On the summary page, charts provide a breakdown of customer feedback for each question.

likert result.png

 

14 Comments
Microsoft

Hi. A few questions about this scale

 

1) Can multiple choice be an option? So far it looks like only one option per statement

2) is there any formatting available such as placing two questions next to each other rather than a top down approach?

3) I see branching available, but is there any other conditional branching?

Occasional Visitor

Hi,

 

Is it possible to link the results from the Likert to Power BI? I made the link but cannot access the results of this questiontype in Power BI.

 

Kind regards,

Edwin

Occasional Visitor

Hello there: I would like to add more than 10 rows on a Likert scale. How can I do that? Thanks, - Juliana

Occasional Visitor

Hi, I exported the responses but only the field type "LIKERT" isn't downloaded. Is it default or a bug?

Microsoft

@Edwin de Ligter, for most of the time, I use "Forms for Excel" to create form to get a live data connection to my Excel workbook (stored in OneDrive for Business). Then I generate the Power BI report based on the Excel Online file.

Microsoft

@Danielle Lindolpho, for each statements you have in the Likert question, you will get a single column in your Excel workbook.Likert.png

Occasional Visitor

Thank you so much @Zhongzhong Li , I didn't realize it was there.

Maybe you can assist me in another issue, I'm using MS Flow for connecting the answers to a Sharepoint list.

The likert field is the only that hasn't been uploaded.Do you know a workaround for this?

 

Settings on ms flow:

flow_1.JPG

 

After workflow runs (PS: I created the column Rate on sharepoint as a multiple lines field):

sharepoint_1.JPG

Occasional Visitor

Hi Danielle, did you solve the problem?, I was looking for a workaround but i did not find anything. I'm having the same issue and I need to move some Forms information to Sharepoint list with a flow, using the likert option in Forms module. If anybody knows something about it, share through this blog.

Microsoft

@Juan Pablo Rodriguez Seco and @Danielle Lindolpho, for Likert in Flow, I think it is a bug, I will double check with our engineers.

Occasional Visitor

@Zhongzhong Li @Juan Pablo Rodriguez Seco and @Danielle Lindolpho

from my side I can not copy the responses of "Likert FORM in Flow" either. the fow always fails with that kind of data.
but it works well with normal text.
can you help find a solution?
Thank you.

Occasional Visitor

@Zhongzhong Li have you found a workaround for exporting likert data via flow to a SharePoint list?
Am desperate for a solution - this would be so beneficial for the quality of data I'm collecting!

Microsoft

Hi @Rafael Herrera@Gabrielle Zlotin@Juan Pablo Rodriguez Seco and @Danielle Lindolpho,

 

Our engineers are working with Flow team on the fix.

 

Regards,

Zhongzhong

Occasional Visitor

I've spent the last couple of days getting closer and closer to a solution but can only get some results sent to my SharePoint list using Flows for the below likert example:

1Likert.JPG

In Flows:

1. Create an action

2. Search 'parse' and select 'Data Operations - Parse JSON'

0Flows.JPG

3. Select the statement you wish to capture with the parse.

1Flows.JPG

In the Schema I used the following:

{
    "type": "object",
    "properties": {
        "id": {
            "type": "number"
        },
        "order": {
            "type": "number"
        },
        "answerOrder": {
            "type": "number"
        },
        "displayText": {
            "type": "string"
        },
        "invalid": {
            "type": "boolean"
        },
        "url": {},
        "description": {},
        "symbol": {},
        "symbolColor": {},
        "isCustomChoice": {
            "type": "boolean"
        },
        "customProperties": {
            "type": "string"
        },
        "key": {},
        "image": {
            "type": "object",
            "properties": {
                "altText": {},
                "contentType": {},
                "fileIdentifier": {},
                "originalFileName": {},
                "resourceId": {},
                "customProperties": {},
                "resourceUrl": {}
            }
        }
    }
}

You may not need all of that as you're trying to capture the "displayText" only.

When sending through the data to SharePoint you would send the dynamic content as below:

2Flows.JPG

 

Issues:

1. If you don't make the likert 'Required', flows will fail when null values come through.  If you need it non-mandatory you'll need to set up conditions and variables to resolve this.

2. This solution managed to get "some" data through to my SharePoint list, however, only two values came through correct.

0Sharepoint.JPG2Likert.JPG

Sandbox - Mon came through - OK

Dev - Came through as Thu - FAIL

Test - Wed came through - OK

DR - Didn't come through

Production - Didn't come through

 

I've confirmed that these values were correct in the flows Excel export so I'm not sure why Forms or Flows switch up the values and drop others:

1Excel.JPG

Occasional Visitor

 Hi There, is it possible to add 10 more rows?  I use this for a Class Attendance tracker and 10 rows just isn't enough.

I'm afraid the competition over at Google Forms is better....   sorry...