SharePoint Document Issues

Fix SharePoint 255-Character Limit in Power Automate and Forms

Olivia MillerOlivia Miller Nov 2, 2026 869 views

Question details

A Power Automate flow fails when syncing Microsoft Forms responses longer than 255 characters to a SharePoint list.

How to Fix the 255-Character Limit in SharePoint and Microsoft Forms
Product
SharePoint and Power Automate
Device & OS
not provided
Scenario
Automating the transfer of long-text survey responses from Microsoft Forms into a SharePoint list.
Observed behavior
The Power Automate flow triggers an error and fails to create the item because the destination SharePoint column is restricted to a maximum of 255 characters.
Before you start

Ensure you have edit permissions for both the destination SharePoint list and the associated Power Automate flow before attempting to modify the column structures.

Solution 1Recommended

Change Column Type and Recreate the Flow Action

Update the SharePoint list column to accept larger text inputs and recreate the Power Automate action to clear the cached column restrictions.

SharePoint defaults to a 'Single line of text' for new columns, capping entries at 255 characters. When Microsoft Forms passes a longer response, Power Automate rejects the action. Modifying the column is only the first step; you must also refresh the flow's schema.

1
Update the SharePoint column

Navigate to your destination SharePoint list. Click the column header causing the issue, select 'Column settings', and choose 'Edit'. Change the data type from 'Single line of text' to 'Multiple lines of text' and save the changes.

2
Locate the failing action in Power Automate

Open your Power Automate flow in edit mode and locate the specific 'Create item' action that is failing during the SharePoint sync.

3
Delete and recreate the action

Delete the existing 'Create item' action entirely. Add a new 'Create item' action in its place and remap your dynamic content from Microsoft Forms. This forces Power Automate to fetch the updated column capacity from SharePoint.

4
Test the automation

Submit a new Microsoft Forms response containing more than 255 characters to verify that the flow now runs successfully and populates the SharePoint list.

Change Column Type and Recreate the Flow Action
Schema Refresh: Deleting and recreating the action is crucial because Power Automate caches the original 255-character limit from the previous SharePoint schema. A simple refresh often doesn't clear this cache.
Free Microsoft Office alternative

Boost Document Productivity with WPS Office

While Power Automate and SharePoint are excellent for complex web workflows, everyday document management is easier with WPS Office. Enjoy a fast, lightweight suite that handles your text documents, spreadsheets, and presentations efficiently without subscription fees.

Highly compatible with Microsoft Office formats including .docx, .xlsx, and .pptxLightweight architecture that runs smoothly on all major operating systemsFree built-in PDF editing, merging, and conversion toolsFamiliar and intuitive user interface for a seamless transition
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Power Automate flow fail with a character limit error?

This error occurs when a Microsoft Forms response exceeds 255 characters and attempts to save into a SharePoint 'Single line of text' column, which enforces a strict 255-character maximum constraint by default.

How many characters can a Multiple lines of text column hold in SharePoint?

A 'Multiple lines of text' column in SharePoint can store up to 63,999 characters, which is more than enough to handle Microsoft Forms long-answer questions (which are capped at 4,000 characters).

Why isn't Power Automate recognizing my updated SharePoint column?

Power Automate caches the previous column schema to optimize performance. To resolve this, you must delete the existing 'Create item' action in your flow and recreate it so the newly applied 'Multiple lines of text' format is recognized.