What is Microsoft Forms? A beginner's guide to questionnaires and registrations in M365 E3/E5
About this article
This article was generated using an automated workflow powered by generative AI. Based on the current Microsoft Forms Service Description and official administrator documentation, it covers everything from form creation to responses, Excel integration, Power Automate, and external sharing as part of a practical workflow.Verification Status: 📘 Confirmed via official Microsoft documentation, physical hardware not tested
Microsoft Forms is a service that allows you to quickly create input screens for surveys, registration forms, polls, and quizzes using a web browser. Responses can be reviewed within Forms, analyzed in Excel, or passed on to downstream processes using Power Automate.input screensMicrosoft Forms is a service that allows you to quickly create input screens for surveys, registration forms, polls, and quizzes using a web browser. Responses can be reviewed within Forms, analyzed in Excel, or passed on to downstream processes using Power Automate.
- Term Definitions
- What is the difference between E3 and E5?
- How does data flow?
- First Trial: Create Just 3 Questions
- Practical Example: Linking Training Registration to Notifications
- Things to Keep in Mind After Exporting to Excel
- If You Are Using Generative AI to Draft Questions
- Perspectives of General Users, Administrative Staff, and IT Admin
- Points for Administrators to Check
- Official and Primary Sources
Term Definitions
| Term | Beginner-friendly meaning |
|---|---|
| Form | The screen where respondents enter information |
| Response | A single submitted entry of input data |
| Branching | A mechanism to change subsequent questions based on the user's answers |
| External Sharing | Allowing individuals outside the organization to respond or co-author |
| Power Automate | A service that automates tasks such as notifications after a Form is submitted |
| Connector | A connection component used by Power Automate to call services like Forms |
What is the difference between E3 and E5?
According to the official Microsoft Service Description, Microsoft Forms is available in both Microsoft 365 E3 and E5. You do not need to assume that Forms is only available in E5 for basic questionnaire creation.
| Item | M365 E3 | M365 E5 |
|---|---|---|
| Forms | Available | Available |
| Form and questionnaire creation | Available | Available |
| Using results in Excel | Available | Available |
| Power Automate integration | Available | Available |
| External responses | Check tenant settings, environment, etc. | Check tenant settings, environment, etc. |
External sharing cannot be determined solely by whether you are on E3 or E5. You must also check the Forms settings in the Microsoft 365 admin center and the cloud environment.
How does data flow?
flowchart LR
A[回答者] --> F[Microsoft Forms\n質問・入力]
F --> R[Formsの回答\n集計・確認]
R --> E[Excel\n分析]
F --> P[Power Automate\n回答をトリガー]
P --> T[Teams / Outlook\n通知など]
M[管理者設定] -.外部共有等を制御.-> F
The key takeaway from this diagram is not to treat Forms itself as the final business system. Forms serves as the data input point, Excel handles analysis, and Power Automate manages downstream processing.
First Trial: Create Just 3 Questions
1. 氏名（テキスト） 2. 参加しますか？（はい / いいえ） 3. コメント（長文）
Submit one test response yourself.
What to check: Verify that the response count and content increase under the Responses tab.
Success criteria: Confirm that the three submitted items are visible.
Change one thing: Set only the second question as mandatory and verify the behavior when it is left unanswered.
Practical Example: Linking Training Registration to Notifications
sequenceDiagram
participant U as 申込者
participant F as Forms
participant P as Power Automate
participant T as Teams/Outlook
U->>F: 申込を送信
F-->>P: 新しい回答を通知
P->>F: 回答の詳細を取得
P->>T: 担当者へ通知
T-->>P: 処理完了
In Power Automate, rather than building approvals, external sending, and data updates all at once,using notifications sent only to yourselfto verify the trigger and response retrieval makes troubleshooting much easier.
Things to Keep in Mind After Exporting to Excel
While it is convenient to handle Forms responses in Excel, creating separate copies of response data for each department makes it difficult to determine which file is the master record. It is important to define the roles of the reporting workbook and the original responses to avoid unnecessary duplication of personal data.
If You Are Using Generative AI to Draft Questions
社内研修後アンケートの質問を5問作ってください。 目的は満足度ではなく「実務で使える状態になったか」の確認です。 誘導的な質問を避け、選択式3問・自由記述2問にしてください。 各質問について、何を測る質問なのかも1行で説明してください。
Success criteriais not simply generating five questions, but being able to clearly explain what each question is designed to measure. To test a change, modify the target audience to "new employees" or "managers" and compare how the questions change.
Perspectives of General Users, Administrative Staff, and IT Admin
| Role | What to verify |
|---|---|
| Respondent | Who can see the responses and what items are mandatory |
| Administrative Staff | How to manage post-response aggregation, notifications, and deadlines |
| Form Creator | How to design anonymous/named responses, branching, mandatory fields, and co-authoring |
| IT Admin | How to govern external sharing, phishing protection, data management, and Power Automate integration |
Points for Administrators to Check
According to Microsoft administrator documentation, external sharing and other settings can be controlled from the Forms settings in the Microsoft 365 admin center. When handling workflows that use external responses, check the organizational settings rather than relying solely on user-level sharing configurations.
Whether to accept responses from external users
Whether to allow co-authoring with external users
Whether response summaries can be shared externally
Whether responses need to be named or can be anonymous
Phishing Protection and Operational Support
Whether personal or sensitive information is truly necessary in the responses
Whether data is being transferred to external services via Power Automate
Official and Primary Sources
Rather than viewing Forms simply as a tool to create questionnaires,Input → Response Review → Analysis → Necessary Downstream Processingthinking of it as an end-to-end data flow makes it much more practical for business use. While basic features are available in both E3 and E5, it is safest to verify organizational settings and data handling policies—not just the license type—when using external sharing and automation.
