Use the Likert, a new survey question type in Microsoft Forms
Published Jan 21 2018 07:24 PM 136K Views
Microsoft

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

 

71 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?

Copper Contributor

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

Copper Contributor

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

Copper Contributor

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

Copper Contributor

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

Copper Contributor

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.

Copper Contributor

@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.

Copper Contributor

@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

Copper Contributor

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

Copper Contributor

 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...

Microsoft

Hi @Brian Donnelly,

 

Thanks for the feedback. I have add it into your backlog.

BTW, do you mind to send me a sample?

 

Regards,

Zhongzhong

Copper Contributor

Hi Zhongzhong Li,

Thank you for answering my query.

I use the 'Likert' as a means of collecting data about student attendances.

An example here...But my classes contain up to 20 students.

10 rows just isn't enough :(

 

Copper Contributor

Hi Zhonzhon Li

 

I am having issue with adding more than ten rows in likert scale and also removing likert options to 4 instead of 5.Screenshot 2018-05-29 16.25.03.png

 

Is there a workaround? 

Copper Contributor

Hi @Zhongzhong Li,

 

As you said "engineers are working with" 05.21 / Do you have any news or progress to connect likert with a list through a flow?. 

 

I will appreciate your comments, thanks.

Microsoft

Hi @Juan Pablo Rodriguez Seco,

 

We have fixed a bug with Flow team, and we are still working on another fix on Forms side.

We will let you know when the fix get on Prod.

 

Regards,

Zhongzhong

Copper Contributor

Hi

 

Is it posible to configure the size of the Colums in likert? in the columns i have only numbers but in the rows i have a long instruction. The form look horrible as displayed

 

Microsoft

@Luis Bozzo Quintana Could you share a screenshot with us?

Copper Contributor

Foto.JPG

Microsoft

Hi @Luis Bozzo Quintana, currently the column size is optimized for options with one or two words. I have added your feedback to our backlog. 

Microsoft

@Rafael Herrera@Gabrielle Zlotin@Juan Pablo Rodriguez Seco@Danielle Lindolpho and @Jason Harris.

Thanks for your patient. We have already fixed the issue for Likert question with Flow team. You should be able to get answers for each statements in Likert in Flow now.

 

Please let me know if you have any further question.

 

Likert - Forms.pngFlow - Likert.png

Copper Contributor

l

Copper Contributor

Hi @Zhongzhong Li, thanks a lot for fixed the issue.

Copper Contributor

@Zhongzhong Li@Juan Pablo Rodriguez Seco@Danielle Lindolpho.... I'm trying to follow this thread but not sure that I saw what the solution is for adding a Likert Scale in MS Forms, using MS Flow to then transfer the form data onto a SharePoint List....  the image I'm seeing above is based on putting the data in to an email body, not putting it into a SP list..... any help would be greatly appreciated

Microsoft

Hi Erika,

 

There was a bug - "Result data in Likert hasn't been exposed based on Options & Statement in Flow". The screenshot tells the bug had been fixed in Flow, so you could get right result data in Flow and put it into SP list / Email body / other connectors.

 

Regards,

Zhongzhong

 

Copper Contributor

All I can create SharePoint list entry when a form response is submitted using the following template:

Mircosoft Forms to SharePoint List Flow Template

 

Once you get to the stage of selecting your SharePoint List, further options appear for each of the columns in said selected list. You then choose which Form item you want to add to each List item. It really is one of the most simple flows I've used (good work Microsoft).


Regarding Likerts on the Form, as one of the earlier posts mention, on the SharePoint List create this column as Single Line Text.

Copper Contributor

Is/can multiple choice be an option? So far it looks like only one option per statement...

Microsoft

@Helen Ozsoy, yes, today for each statement you could only have one option as the answer.

Could you share more detail about your questions / survey that need Likert with multiple answers?

 

Regards,

Zhongzhong

Copper Contributor

I was wondering about multiple answers to a Likert question, just like @Helen Ozsoy. I am relatively new to O365 forms, so not sure if this format makes sense or now.

 

I am trying to track days that people can volunteer for an event, something like this:

October.PNG

Since only one answer is available on the Likert questions (as of right now), is there another way to frame this up so that I can easily collect information without causing more work for my team?

Microsoft

Thanks @Lindsey Troy for the screenshot, it is very helpful.

I have record your feedback and shared with my team.

 

Regards,

Zhongzhong

 

Copper Contributor

Dear Microsoft, 

 

I use likert question type in Microsoft Forms but it only can add questions no more than 10 question. Is there any chance I could add more than 10 questions? Because my question is up to 20. I would love to use microsoft forms in my organization to release survey, need your advice to make it success.. thankyou..

Copper Contributor

Hi There I have been looking for extra statements on the Likert Question type.  See my post, of ‎05-24-2018 07:41 AM.  there are a few of us now see Firdha Novha Nur Hassanah, null Sonam and Juliana Trammel all above.

 

Deleted
Not applicable

Hi there. I am using MS Forms and the likert scale with and added option. It works fine, also I am able to transfer the responses to SPO nicely.

I have over 70 statements in the question. Is there a way to import them all at once, not one by one. I also want to keep the statements in alphabetical order, how is that done?

Copper Contributor

likert.png

Is there any way to make a Likert only allow one selection per rank?  I want users to rank these training types from 1 to 6 without winding up with 6 #1 ranks. I saw the other way was to select the Ranking but that works with arrows and the arrows are row specific (i.e., you have to keep chasing the same item over and over to move down more than one line). My manager thought that was too confusing. Thanks, in advance, for the assist!

Copper Contributor

I have seen this question asked before but never saw an answer. Is there a way to do multiple select on this? I need it for my class for a professionalism grade scale. Thanks in advance for any assistance!

Microsoft

@TiffHam , we don't support multiple selection for Likert now.

 

Could you let us know more about your story. E.g. what is the question title, and what's the rows / columns name. And also how do you want to check the result in the summary page.

 

Copper Contributor

Hi, 

 

Can someone explain how to add more than 10 statements on the Likert scale? I did not get how to do that.

Thank you.

Copper Contributor

Hi otiliahara, the queue for this is long.  See posts above from Firdha Novha Nur Hassanah, null Sonam, Juliana Trammel and myself above :(

Copper Contributor

@Brian Donnelly  Hi, thank you for the reply. So there is no option? No workaround?

Copper Contributor

@otiliahara ... Use a second Likert question... then you have 20 :)

Copper Contributor

@Brian Donnelly thank you. and then you merge the answers manually in the Excel file? I have to use then the SPSS tool so I would be grateful if you can advise on this one. :)

Copper Contributor

Yes @otiliahara the 2 (or more) Likert Questions will 'merge' onto the one Excel Sheet in the background.  From here you can manipulate at will with various formulas.  If I am honest.  Google Forms and their resulting sheets are a lot more user friendly.  I use both.

Good Luck

Copper Contributor

+1 for more than 10 options

Copper Contributor

Hi

 

This is another request to allow multiple answers in the grid per statement. I am trying to find out people's availability to support 24/7 coverage. For example, someone might be available for 1st and 2nd shift on Oct 7th, so I would like the option for them to choose 2 for Statement "Mon Oct 7th". Also, more than 10 statements would be nice, but I can work around that with doing multiple questions. Unfortunately without the feature to allow multiple answers in the grid, I have to use another tool. 

Capture.JPG

 
Copper Contributor

We have a problem with the results of a Likert Scale.

 

We used a Likert scale in a questionaire - a total of 12 questions with 6 options. The question is mandatory. The entire form contains 7 questions - some of them are choice questions as well.

 

Both in the results in MS Forms itself, as well as in the Excel results spreadsheet we are only seeing entries of "strongly agree" (right maximum). All other fields are blank. In other words if a user selected any other value than "strongly agree", we are not seeing this value in the results. The graph in Forms, however seems to display data containing all values entered.

 

We are at a loss... any ideas?

Copper Contributor

@Zhongzhong Li  and all ... I notice lately it is no possible to have up to 20 'statements' on a Likert Scale.  At last.  Thank you whoever set this up. :smile:

Copper Contributor

:smile:

Version history
Last update:
‎Jan 22 2018 05:11 AM
Updated by: