Fix SharePoint 255-Character Limit in Power Automate and Forms
Question details
A Power Automate flow fails when syncing Microsoft Forms responses longer than 255 characters to a SharePoint list.

- 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.
Ensure you have edit permissions for both the destination SharePoint list and the associated Power Automate flow before attempting to modify the column structures.
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.
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.
Open your Power Automate flow in edit mode and locate the specific 'Create item' action that is failing during the SharePoint sync.
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.
Submit a new Microsoft Forms response containing more than 255 characters to verify that the flow now runs successfully and populates the SharePoint list.

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.

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.




