Others

How to Display Full Text in Microsoft Forms Reports

Partner Editor Sep 28, 2026 869 views

Question details

Users need a way to view and share complete, un-truncated text responses in Microsoft Forms reports.

How to Display Full Text in Microsoft Forms Reports

Product: Microsoft Forms
Device & OS: not provided
Scenario: Reviewing text-heavy feedback summaries or sharing report links with team members.
Observed behavior: Microsoft Forms report summaries automatically truncate long text responses after one or two lines, resulting in incomplete feedback when viewing or sharing reports.

Before you start

Ensure you have access to Power Automate with your Microsoft 365 subscription, as Microsoft Forms currently lacks a built-in toggle to expand long text in the standard web report view.

Solution 1Recommended

Use Power Automate to Export Complete Responses

Since the web report view limits text length, you can use Power Automate to extract the full answers and automatically generate a complete email or table.

Power Automate connects directly to the Microsoft Forms API, allowing you to bypass the visual limitations of the summary page and extract the raw, un-truncated text data as soon as a form is submitted.

Create a new automated cloud flow

Set the Forms trigger

Search for and select the trigger named 'When a new response is submitted'. Pick your specific form from the dropdown list.

Retrieve the response details

Add a new step, search for the 'Get response details' action, and select it. Enter the Form Id again and use the 'Response Id' dynamic content for the second field.

Output the full text

Add another step to determine where the data goes, such as 'Send an email (V2)' or 'Add a row into a table' (Excel). Use the dynamic text variables from your form's questions to insert the complete, un-truncated answers into your destination.

Use Power Automate to Export Complete Responses

Submit Feedback to Microsoft: Because there is no native solution in the report dashboard, consider submitting product feedback to Microsoft requesting an 'expand text' feature in the summary view.

Solution 2

Export Responses Manually to Excel

For a quick workaround without automation, you can download all form responses directly to a spreadsheet where text is not truncated.

Free Microsoft Office alternative

Analyze Form Exports with WPS Office

Because Microsoft Forms limits text display in web reports, exporting your responses to a spreadsheet is often necessary. You can seamlessly open, view, and organize these exported Excel files using WPS Office—a free, lightweight, and highly compatible office suite.

1. Open the exported file: After clicking 'Open in Excel' in Microsoft Forms, open the downloaded .xlsx file using WPS Spreadsheet.
2. Format for readability: Select the columns containing your long text responses.
3. Wrap text: Click the 'Wrap Text' button in the Home tab to instantly view the complete feedback without truncation.

100% compatible with Microsoft Excel (.xlsx) files exported from FormsFree and lightweight alternative for viewing and analyzing dataUser-friendly interface for wrapping text and formatting long text responsesFamiliar UI with zero learning curve for new users

microsoft office alternative - wps office

Frequently Asked Questions

Is there a setting in Microsoft Forms to show full text in the summary?

No, Microsoft Forms does not currently provide a native setting or toggle to prevent long text responses from being truncated in the standard report summary view.

Why does my shared report link show incomplete feedback?

The shared summary link is an exact mirror of the web report view. To save space and maintain layout consistency, Microsoft automatically truncates text after one or two lines for all users viewing the link.

How can I share complete form responses with my team?

You can export the responses to an Excel spreadsheet and share that file with your team, or set up a Power Automate flow to automatically send the complete text responses to a shared Teams channel or shared mailbox.

Office Quick Solutions