Creating MS Form With All Supported Data Types

Introduction

Microsoft forms are a lightweight powerful tool that helps in creating surveys, polls, and  quizzes which helps in analyzing results quickly by inbuilt reports. In this article series, the below steps are involved.

• Creating the forms with all the existing datatypes
• How to record each data type in SharePoint.

Here I want to have SharePoint as a data source to store all the form responses.

Here the assumption is you have a basic subscription of E1 or E3 with your organization. If you do not have one, get the developer tenant created from MSFT which is free of cost.

Creating a simple form using Microsoft Forms with all data types

Please follow the below steps to create the forms using Microsoft Forms.

Step 1

Go to Microsoft Forms by going to URL https://forms.microsoft.com with your subscription ID.

Step 2

From the home page, click on ‘New Form’.

Step 3

Name the form and provide a description. Here I am selecting as ‘Workshop Feedback’.

Step 4

Start adding the questions. Here we are creating all datatypes that currently MS Forms is supporting.

• Choice
• Text
• Rating
• Net Promoter Score
• Date
• Ranking
• Likert
• File Upload
• Net Promoter Sore

Step 5

Select question of type ‘Choice’. Here I am adding the question ‘How satisfied you are with the workshop’. The moment the question is entered, you will have the suggestions appeared with options. for simplicity, I am selected ‘add all’. Also, I am keeping the defaults which are m=Multiple choices to No, and ‘Required’ property to No.

Step 6

Select the next question, by selecting of type ‘Text’. Here I am entering, ‘How the workshop can be improved?’

Step 7

Next, select the question of type ‘Rating’ and here I am entering the question ‘Your overall rating for the Workshop?’

Step 8

Next, select the datatype as ‘Date’ and here I am entering the question ‘The date the Workshop has conducted’?

Step 9

Now select the data type ‘Ranking’, and here I am entering the description as ‘Rank the following topics based upon your expertise. I have entered options as Power Automate, Power Apps, Power Virtual Agents, Power BI.

Step 10

Next, select the data type of type ‘Likert’ and then enter the description as ‘How satisfied you are with the following aspects of the Workshop?

Note
‘Likert’ is a special type that is used to measure the opinions on specific topics.

Like in the previous steps, I have chosen to ‘Add All’ based on suggestions provided by Forms. Below is the final question of type ‘Likert’.

Step 11

Now select the data type ‘File Upload’ and enter the description as ‘Upload the completed lab modules’ and configure the no. of files limit to 2 and leave the upload limit as default.

The moment you clicked on the ‘File Upload’ you will be getting a message saying that a folder will be created in OneDrive. select Ok.

Step 12

Next, select the datatype ‘Net Promoter Score’ and enter the description, ‘How likely you recommend this workshop to a friend or colleague’?

The below 2 questions I am creating to show how to record multi-choice and single choice dynamic values from ‘Form Responses’ to SharePoint list.

Step 13

Select the datatype as a choice, and I am entering the question ‘What training modules you liked most’. Here I am configuring datatype as a multi-choice option.

Step 14

Now select the same datatype choice, now configure this as a single option, and enter the description ‘Avg suggested time for Workshop’?

Conclusion

Thus, in this article, we have completed creating forms with all the supported datatypes and in the next article, we will see how to capture all the form responses in a SharePoint list.

References

• https://developer.microsoft.com/en-us/microsoft-365/dev-program
• https://www.c-sharpcorner.com/article/how-to-record-microsoft-form-responses-in-sharepoint-using-microsoft-flow/