Others

How to Build a Student Document Tracking System with Microsoft 365

Adam Davis Oct 21, 2026 868 views

Question details

The user wants to create an automated system to collect student submissions, track missing documents, assign exam dates, and manage access permissions for both students and staff.

How to Build a Student Document Tracking System Using Microsoft 365

Product: Microsoft 365
Device & OS: not provided
Scenario: Creating an end-to-end workflow to handle student document submissions, staff reviews, and automated email notifications.
Observed behavior: Integrating Microsoft Forms, SharePoint Online, and Power Automate into a unified tracking system with controlled access rights.

Before you start

Ensure you have a Microsoft 365 subscription with active licenses for Microsoft Forms, SharePoint Online, and Power Automate, and possess site owner permissions to configure lists and advanced access controls.

Solution 1Recommended

Build the Tracking Workflow with Forms, SharePoint, and Power Automate

This solution connects Microsoft 365 tools to automatically transfer student submissions into a secure database, trigger notifications, and strictly control who can view the records.

By combining Microsoft Forms for data entry, a SharePoint List for secure data storage, and Power Automate for routing, you can create a robust tracking system without writing code. This integration ensures students are kept informed of their status while staff can efficiently manage examination dates and missing files.

Create a Submission Form in Microsoft Forms

Go to Microsoft Forms and create a new form. Add fields for student information (Name, Student ID) and a 'File Upload' question for document submissions. Ensure the form is set to record the names of the respondents.

Set Up a SharePoint Online List

Navigate to your SharePoint site and create a new List. Add columns to track specific statuses, such as 'Missing Documents' (Choice column), 'Submission Status' (Choice column), and 'Examination Date' (Date and Time column). This will act as your master tracking database.

Configure SharePoint Permissions

To ensure students only see their own records, go to your SharePoint List. Click the gear icon > 'List settings' > 'Advanced settings'. Under 'Item-level Permissions', select 'Read items that were created by the user' and 'Create items and edit items that were created by the user'. Site owners (staff) will still be able to view all items.

Build a Power Automate Flow

Open Power Automate and create an 'Automated cloud flow'. Use the trigger 'When a new response is submitted' (Microsoft Forms). Add an action 'Get response details', followed by 'Create item' (SharePoint) to map the form answers to your SharePoint list columns.

Add Notification Actions

Within the same Power Automate flow, add a 'Send an email (V2)' action to notify the student that their submission was received. You can create additional scheduled flows later to check for empty 'Examination Date' fields and alert staff to assign them.

Build the Tracking Workflow with Forms, SharePoint, and Power Automate

Power Automate Community Support: Building complex workflows can be challenging. If you encounter errors mapping form data to SharePoint, the Microsoft Power Automate Community is an excellent resource for troubleshooting specific flow logic.

Free Microsoft Office alternative

Review Student Documents Efficiently with WPS Office

While Microsoft 365 handles the backend tracking workflows, reviewing the actual student document submissions requires a reliable office suite. WPS Office is a lightweight, fully compatible, and free alternative to Microsoft Office that lets staff quickly open, edit, and annotate student files.

1. Download and Install WPS Office: Download WPS Office for free from the official website and install it on your Windows, Mac, or Linux computer.
2. Open Exported Student Submissions: Double-click any downloaded Word document, Excel spreadsheet, or PDF from your SharePoint list to instantly open it in WPS Office's unified interface.
3. Review and Annotate: Use the integrated Review tab or PDF tools to add comments, highlight text, and efficiently grade or verify the submitted student documents.

Fully compatible with Microsoft Word, Excel, and PowerPoint formats.Built-in PDF toolkit allows staff to highlight and annotate student submissions for free.Lightweight application that opens large batches of documents rapidly.Familiar tabbed interface makes reviewing multiple student files seamless.

microsoft office alternative - wps office

Frequently Asked Questions

Are file uploads in Microsoft Forms stored directly in the SharePoint list?

No, file uploads via a Group Form are stored in the default Document Library of the SharePoint site, while the SharePoint List stores the metadata and a link to the uploaded file. You must map this link using Power Automate.

How do I send automated reminders for missing documents?

You can create a 'Scheduled cloud flow' in Power Automate that runs daily or weekly. Configure it to 'Get items' from the SharePoint list, filter for rows where the 'Missing Documents' column is not empty, and use a 'Send an email' action to notify those specific students.

Can external users (non-students without an organizational account) upload files to the form?

By default, the 'File Upload' feature in Microsoft Forms requires respondents to sign in with an organizational account (e.g., a student email). If you need external users to submit files, you may need to use external sharing links in OneDrive or a third-party portal integrated with Power Automate.

Office Quick Solutions