'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Show Only the Latest Microsoft Forms Response
Question details
The user wants to display or filter Microsoft Forms responses so that only the most recent submission is visible to the recipient.
- Product
- Microsoft Forms
- Device & OS
- not provided
- Scenario
- Reviewing or sharing Microsoft Forms submissions without exposing previous historical data.
- Observed behavior
- Microsoft Forms currently displays all historical responses together and lacks a native toggle to isolate or send only the newest entry.
Ensure you have owner or editor permissions for the Microsoft Form, as you will need access to the Responses tab to export the data or link to Power Automate.
Open Form Responses in Excel
Exporting your form data to Excel allows you to quickly locate the newest entry, which is automatically added to the bottom of the dataset.
Since Microsoft Forms does not have a built-in feature to hide past responses in its web view, exporting the data to a spreadsheet is the most straightforward workaround.
Log in to Microsoft Forms and open the specific form you want to review.
Click on the 'Responses' tab located at the top of the form design page.
Click the 'Open in Excel' button to download the responses spreadsheet.
Open the downloaded Excel file and scroll to the very bottom of the data rows. The last row represents the newest submission.
Automate Notifications with Power Automate
Use Power Automate to isolate the newest response as it comes in and send it directly to your email without the historical data.
Analyze Exported Form Data with WPS Office
Because Microsoft Forms requires exporting data to a spreadsheet to isolate recent responses, you need a reliable spreadsheet tool. WPS Office offers a free, lightweight, and highly compatible alternative to Microsoft Office for opening, filtering, and analyzing your exported form data effortlessly.
- 1. Download and install: Download WPS Office Free from the official website and install it on your device.
- 2. Locate exported file: Find the Excel (.xlsx) file you exported from Microsoft Forms in your Downloads folder.
- 3. Open and analyze: Right-click the file, select 'Open with WPS Office', and use WPS Spreadsheet to view the latest responses at the bottom.
Frequently Asked Questions
Does Microsoft Forms have a built-in feature to show only the newest response?
No, Microsoft Forms currently lacks a native option to hide past responses and display only the most recent one to recipients. You must export the data or use Power Automate as a workaround.
Where is the newest submission located in the exported Excel file?
When you open Microsoft Forms responses in Excel, the latest submission is automatically appended to the bottom of the dataset and will have the highest ID number.
How can I suggest adding this feature to Microsoft Forms?
You can submit a feature request or upvote existing requests on the official Microsoft Forms Feedback Community portal to encourage developers to add a 'latest response only' view.
