Others

How to Create an Audit Trail for Edited Microsoft Forms Responses

Huma Ashraf Ch Sep 28, 2026 868 views

Question details

The user wants to know if it is possible to retain original responses when a respondent edits them and how to create a response history or audit trail in Microsoft Forms.

How to Create an Audit Trail for Edited Microsoft Forms Responses

Product: Microsoft Forms
Device & OS: not provided
Scenario: Tracking response history and retaining original submissions when users edit their form answers.
Observed behavior: Microsoft Forms does not natively retain a visible revision history or provide an automatic audit trail for edited responses.

Before you start

Ensure you have access to Microsoft Power Automate and an active data storage destination, such as an Excel Online spreadsheet or a SharePoint list, to log the automated response data.

Solution 1Recommended

Use Microsoft Power Automate to Record Form Revisions

Create an automated flow to capture each form submission and store the timestamp and data in an external source like Excel or SharePoint to build your own audit trail.

Since Microsoft Forms does not automatically provide a complete revision history for edited responses, you need to rely on Microsoft Power Automate. By setting up a cloud flow, you can capture every submission instance and push the data into an external database, allowing you to track changes over time.

Create a new automated cloud flow

Set the Forms trigger

Search for the Microsoft Forms triggers, choose 'When a new response is submitted', and select your specific form from the dropdown menu.

Get response details

Add a new step, search for 'Get response details', select your form again, and map the 'Response Id' from the dynamic content.

Log data to an external source

Add a final action such as 'Add a row into a table' (for Excel Online) or 'Create item' (for SharePoint). Map the form response fields and include a submission timestamp column to track revisions.

Use Microsoft Power Automate to Record Form Revisions

Community Support: For advanced scenarios involving condition-based edits, consider posting in the Microsoft Power Automate Community for specialized guidance on custom flow expressions.

Free Microsoft Office alternative

Analyze Your Form Response Data with WPS Office

While you use Power Automate to capture your Microsoft Forms audit trail into an Excel file, use WPS Office as a lightweight, free alternative to Microsoft Office to view and analyze that exported data. It features complete format compatibility and a familiar, user-friendly interface.

Free and lightweight comprehensive Office suiteFully compatible with Microsoft Excel (.xlsx) formatsPowerful data analysis and pivot table toolsFamiliar user interface for seamless migration

microsoft office alternative - wps office

Frequently Asked Questions

Does Microsoft Forms keep original responses if a user edits them?

No, Microsoft Forms natively overwrites the original response when a user edits their submission. It does not automatically retain a visible revision history.

Can I track timestamps for edited Microsoft Forms?

Yes, but you must use Microsoft Power Automate to log submissions into an external database like SharePoint or Excel. This allows you to capture the exact timestamp of every individual submission or edit attempt.

Where can I get help building a flow for Forms revisions?

The Microsoft Power Automate Community is the best official resource for finding specialized guidance, troubleshooting tips, and pre-built templates for complex form-tracking workflows.

Office Quick Solutions