Others

Can Power Automate Delete Spam Microsoft Forms Responses?

Aamir Naveed Akram Oct 9, 2026 870 views

Question details

The user wants to know if they can use Power Automate to automatically identify and delete individual spam responses in Microsoft Forms using the response ID.

Can Power Automate Delete Spam Microsoft Forms Responses?

Product: Microsoft Forms and Power Automate
Device & OS: not provided
Scenario: Automating the management and cleanup of unwanted or spam form submissions.
Observed behavior: Currently, Microsoft Forms does not provide a built-in standard Power Automate action or API operation to delete a specific response by its response ID.

Before you start

Ensure you have Owner or Co-author permissions for the Microsoft Form and have access to the connected Excel workbook where the responses are stored.

Solution 1Recommended

Manually Delete Spam Responses in Microsoft Forms

Since Power Automate cannot delete responses by ID, you must manually remove them directly within the Microsoft Forms interface.

While Power Automate can detect and route suspicious submissions differently, the original record inside the Microsoft Forms interface can only be purged through manual deletion.

Open Microsoft Forms

Log in to your Microsoft 365 account, open Microsoft Forms, and click on the form containing the spam responses you wish to remove.

Navigate to the Responses Tab

Click on the 'Responses' tab located at the top of the form design page to view a summary of all submission data.

View Results and Delete

Click the 'View results' button. Locate the specific spam response using the respondent name or response ID, click the three-dot menu (More options) on the right side, and select 'Delete response'.

Manually Delete Spam Responses in Microsoft Forms

Permanent Action: Deleting a response directly in Microsoft Forms is permanent and cannot be undone. Ensure you are deleting the correct entry.

Solution 2

Automate Spam Deletion in the Excel Destination

Instead of trying to delete the response from Forms, use Power Automate to automatically remove the spam entry from the destination Excel spreadsheet.

Free Microsoft Office alternative

Filter Form Responses Easily with WPS Office

If you export your Microsoft Forms data to Excel, you can use WPS Spreadsheet to quickly sort, filter, and delete spam responses manually. WPS Office is a free, lightweight, and highly compatible alternative to Microsoft Office that handles data management seamlessly.

1. Open your Form Data: Export your Microsoft Forms responses to Excel and open the resulting .xlsx file in WPS Spreadsheet.
2. Apply Data Filters: Highlight your header row, navigate to the Data tab, and click the Filter button to enable drop-down menus on your columns.
3. Remove Spam: Filter your columns for suspicious keywords or blank entries, highlight the spam rows, right-click, and choose Delete to instantly clean your dataset.

Highly compatible with Microsoft Excel (.xlsx) formatsFree, lightweight, and fast-loading Office suiteFamiliar user interface for seamless migrationAdvanced filtering tools to easily isolate and remove spam entries

microsoft office alternative - wps office

Frequently Asked Questions

Can I use an HTTP request in Power Automate to delete a Forms response?

No. Microsoft currently does not expose a public API endpoint that allows you to delete individual Microsoft Forms responses via custom HTTP requests in Power Automate.

How can I prevent spam responses in Microsoft Forms?

To reduce spam, change your form settings to 'Only people in my organization can respond' if applicable, which requires a login. For public forms, avoid posting direct links on public forums to prevent bots from easily scraping them.

If I delete a response in the connected Excel file, is it removed from Forms?

No, deleting a row in your connected Excel workbook or a SharePoint list does not remove the original submission data from the Microsoft Forms dashboard. Those must be deleted manually from the Forms UI.

Office Quick Solutions