Microsoft Forms + SharePoint: Data Collection Guide

Introduction

Data collection drives decisions. Whether gathering employee feedback, processing customer requests, or running approval workflows, organizations need reliable ways to capture structured information. Microsoft Forms provides intuitive form creation; SharePoint provides robust data storage and management.

This guide covers the complete integration between Microsoft Forms and SharePoint—from basic form creation to sophisticated automated workflows.

Microsoft Forms Fundamentals

Form Types

Standard Forms

• Unlimited responses
• External sharing available
• Analytics and reporting
• Branch logic support

Quizzes

• Automatic grading
• Points assignment
• Correct answer feedback
• Results sharing options

Creating Forms

From Office 365

• Go to forms.microsoft.com
• Click "New Form"
• Add title and description
• Add questions

From SharePoint

• In modern list: New → Forms for Excel
• Creates linked form automatically
• Responses stored in SharePoint list

Question Types

Input Options

• Choice (single or multiple)
• Text (short or long)
• Rating (stars or numbers)
• Date
• Ranking
• Likert scale
• Net Promoter Score
• File upload

Form Settings

Response Options

```

• Accept responses: On/Off
• Start date: Schedule opening
• End date: Schedule closing
• Shuffle questions: Randomize order
• Show progress bar: Enable/disable
• Response receipts: Send confirmations

```

Sharing Settings

```

• Only people in my org can respond
• Anyone with the link can respond
• Specific people in my org

```

Connecting Forms to SharePoint

Method 1: Forms for Excel Integration

Creating Connected Form

• Open SharePoint list
• Click "Integrate" → "Power Apps" → "Create an app"

Or: "New" → "Forms for Excel"

• Form automatically writes to list

Advantages

• Automatic column mapping
• Real-time sync
• No Power Automate required
• Simple setup

Limitations

• Limited customization
• Must use existing list structure
• Basic routing only

Method 2: Power Automate Integration

Standard Flow

```

Trigger: When a new response is submitted (Forms)

Action: Create item (SharePoint)

```

Detailed Steps

• Go to Power Automate
• Create automated cloud flow
• Trigger: "When a new response is submitted"
• Select your form
• Add action: "Get response details"
• Add action: "Create item" (SharePoint)
• Map form fields to list columns

Mapping Example

```

Form Field → SharePoint Column

responderEmail → SubmittedBy

Question 1 (Name) → CustomerName

Question 2 (Request Type) → RequestType

Question 3 (Description) → Description

Question 4 (Priority) → Priority

```

Method 3: Power Apps Custom Forms

When to Use

• Complex validation requirements
• Multi-step processes
• Custom UI needs
• Integration with multiple data sources

Power Automate Workflows

Basic Response Notification

```

Trigger: When a new response is submitted

Actions:

• Get response details
• Send email (V2)
• To: [email protected]
• Subject: New Form Response
• Body: Dynamic content from form

```

Response Routing by Answer

```

Trigger: When a new response is submitted

Actions:

• Get response details
• Condition: Department equals "HR"

Yes → Create item in HR Requests list

No → Continue

• Condition: Department equals "IT"

Yes → Create item in IT Tickets list

No → Create item in General Requests list

```

Approval Workflow

```

Trigger: When a new response is submitted

Actions:

• Get response details
• Create item in SharePoint (Status: Pending)
• Start approval (Approvers: Manager)
• Condition: Approval outcome

Approved → Update item (Status: Approved)

Rejected → Update item (Status: Rejected)

• Send email to responder with outcome

```

File Upload Handling

```

Trigger: When a new response is submitted

Actions:

• Get response details
• Download file (from file upload question)
• Create file in SharePoint document library
• Create item in list with file link

```

Enterprise Survey Scenarios

Employee Feedback Survey

Form Structure

```

Section 1: Overall Satisfaction

• Rating: Overall job satisfaction (1-10)
• Choice: Department
• Choice: Role level

Section 2: Specific Areas

• Likert: Management communication
• Likert: Career development
• Likert: Work-life balance

Section 3: Open Feedback

• Long text: What's working well?
• Long text: What could improve?

```

SharePoint Integration

```

Responses List:

• SubmissionDate (Date)
• OverallSatisfaction (Number)
• Department (Choice)
• RoleLevel (Choice)
• ManagementScore (Number)
• CareerScore (Number)
• WorkLifeScore (Number)
• PositiveFeedback (Multi-line text)
• ImprovementFeedback (Multi-line text)

```

IT Service Request

Form Structure

```

• Text: Your name
• Text: Email
• Choice: Request type (New hardware, Software access, Issue report)
• Text: Description
• Choice: Priority (Low, Medium, High, Critical)
• File upload: Screenshots (optional)

```

Workflow

```

• Response creates SharePoint list item
• Assigns to IT queue
• Sends confirmation to requester
• If Priority = Critical, sends Teams alert
• Updates ticket status throughout lifecycle

```

Event Registration

Form Structure

```

• Text: Full name
• Email: Work email
• Choice: Session selection (morning/afternoon)
• Choice: Dietary requirements
• Choice: T-shirt size (optional)
• Long text: Special accommodations

```

Capacity Management

```

Flow Logic:

• Get response
• Query SharePoint for current count
• If count < capacity:
• Add registration
• Send confirmation
• Else:
• Add to waitlist
• Send waitlist notification

```

Reporting and Analytics

Built-in Forms Analytics

Available Metrics

• Total responses
• Average completion time
• Question-by-question summary
• Individual response review
• Excel export

Accessing Analytics

• Open form in Forms
• Click "Responses" tab
• View summary charts
• Click "Open in Excel" for raw data

SharePoint List Analytics

Power BI Integration

• Create Power BI report
• Connect to SharePoint list
• Build visualizations
• Share dashboard

Quick Charts in SharePoint

• Open list view
• Click column header
• Select "Show as chart"
• Basic visualization appears

Custom Reporting

```powershell

# Export form responses from SharePoint list

$responses = Get-PnPListItem -List "Survey Responses" -PageSize 1000

# Generate summary report

$summary = $responses | Group-Object { $_.FieldValues.Department } |

Select-Object Name, Count, @{

Name = "AvgSatisfaction"

Expression = {

($_.Group | Measure-Object { $_.FieldValues.Satisfaction } -Average).Average

}

}

$summary | Export-Csv "SurveyReport.csv" -NoTypeInformation

```

Advanced Integration Patterns

Multi-Step Forms

Scenario: Break long forms into pages

Implementation

• Create multiple forms
• Link with "Thank you" redirect
• Use common identifier across forms
• Power Automate combines responses

Conditional Form Display

Using Branching

• In form design, click question
• Click "..." → "Add branching"
• Set "Go to" based on answer
• Create separate paths

Pre-Filled Forms

URL Parameters

```

Base URL: https://forms.microsoft.com/e/abc123

Pre-fill: ?Q1=John&Q2=HR

Full URL: https://forms.microsoft.com/e/abc123?Q1=John&Q2=HR

```

Dynamic Pre-Fill with Power Automate

• Generate personalized form links
• Include known data in URL
• Send via email to recipients
• Track which links were used

Form Templates

Creating Templates

• Design form
• Click "..." → "Copy"
• Share as template
• Others duplicate for their use

Security and Compliance

Response Protection

Anonymous Responses

• No responder identification
• IP addresses not logged
• Good for sensitive topics

Identified Responses

• Responder email captured
• Prevents duplicate submissions
• Required for follow-up

Data Retention

Forms Retention

• Responses remain until form deleted
• Form owners control data lifecycle
• Export before deletion

SharePoint Retention

• Apply retention policies to lists
• Automatic archival/deletion
• Compliance holds available

Access Control

```

Form: Control who can fill out

SharePoint: Control who can view responses

Power Automate: Control who can manage workflow

```

Troubleshooting

Responses Not Reaching SharePoint

Checklist

• Flow enabled and running?
• Connection credentials valid?
• List columns match form fields?
• Check flow run history for errors

Common Errors

• "Item not found" - List or column deleted
• "Unauthorized" - Connection expired
• "Bad request" - Data type mismatch

Duplicate Responses

Causes

• User submitted multiple times
• Flow retried on error
• Browser refresh during submission

Prevention

• Enable "One response per person"
• Add duplicate detection in flow
• Use unique identifiers

Form Not Loading

Troubleshooting

• Clear browser cache
• Try incognito mode
• Check form is still accepting responses
• Verify sharing settings

Best Practices

Form Design

User Experience

• Keep forms short
• Use clear question text
• Group related questions
• Provide progress indicator
• Mobile-friendly design

Data Quality

• Use appropriate question types
• Add validation where possible
• Make required fields clear
• Test before deploying

SharePoint Integration

List Design

• Match column types to form data
• Use choice columns for consistency
• Plan for reporting needs
• Consider views for different audiences

Workflow Design

• Handle errors gracefully
• Send confirmations
• Log all actions
• Plan for retries

Conclusion

Microsoft Forms and SharePoint together create powerful data collection and management solutions. Forms provide intuitive user experiences; SharePoint provides structured storage; Power Automate connects them with intelligent workflows. The combination supports everything from simple feedback collection to complex enterprise processes.

Ready to implement integrated data collection? Contact our specialists for Forms and SharePoint integration consulting.