Skip to main content

Notifications

Community site session details

Community site session details

Session Id : ZmBYaHaKg3PU86abEbL/sq
Power Automate - Using Flows
Answered

Sharepoint list 255 char limit with Multiple line of text

Like (3) ShareShare
ReportReport
Posted on 27 Mar 2020 16:00:23 by 19

Hi All,

I've built a simple automation flow that from a form it fills the answers in a SharePoint list.

However I've just stumbled in the 255 limit. Reading online I've found that changing the column format in SharePoint to Single line of text to Multiple line of text should solve the issue, however I'm keeping having the same issue:

 

The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: The API operation 'PostItem' requires the property 'item/SubscriptionID' to be a string of maximum length '255' but is of length '2578'.

 

How can I bypass this? Multiple line ox text should not have the 255 char limit

 

Thanks

 

Carlo

  • WillianSantos Profile Picture
    3 on 27 Dec 2023 at 18:55:10
    Re: Sharepoint list 255 char limit with Multiple line of text

    Thanks! It worked fine and quickly

  • Susan_D Profile Picture
    2 on 15 May 2023 at 17:23:27
    Re: Sharepoint list 255 char limit with Multiple line of text

    I have a MS Form-to-Sharepoint flow that failed for this problem. Thankfully I found this post. To resolve, I updated my Sharepoint by changing from 'single' to 'multiple' lines of text. Next, I updated the flow by deleting the Form response, then added the same Form response back into the flow, then saved. Once I re-ran the flow the 'failed' flow succeeded and responses were populated on the Sharepoint. 

     

    As a lessons learned, I will also double/triple check in the future to make sure that the Form responses and Sharepoint field character limitations align. This didnt fail during testing or right away during actual use since testing/user responses were < 255 characters. 

     

    Thanks for posting the solution!!

  • c_tepe Profile Picture
    4 on 22 Mar 2023 at 22:51:17
    Re: Sharepoint list 255 char limit with Multiple line of text

    This worked perfectly for me, and was very quick! Thanks so much.

  • Kwad1z Profile Picture
    3 on 18 Nov 2022 at 09:52:06
    Re: Sharepoint list 255 char limit with Multiple line of text

    this solution solved my problem real quick. cheers!!

  • jrm315 Profile Picture
    8 on 01 Sep 2022 at 12:52:15
    Re: Sharepoint list 255 char limit with Multiple line of text

    Awesome, this worked! Thank you!

  • Cassie_Price Profile Picture
    5 on 24 Jan 2022 at 21:50:42
    Re: Sharepoint list 255 char limit with Multiple line of text

    Thank you!! I was nervous to edit my existing list too much since it's currently being used (and this is the first time we've encountered this error). Switching the action to a different list and then switching back worked like a charm!

  • simondoy Profile Picture
    32 on 11 Oct 2021 at 09:34:26
    Re: Sharepoint list 255 char limit with Multiple line of text

    You can save yourself some time by changing the list in the existing action, choose another list, wait for the screen to refresh and then choose the original list.

    Hopefully, then the change does not impact your flow as much as removing the action.

     

    Cheers

  • krishankumar Profile Picture
    2 on 10 Sep 2021 at 08:11:39
    Re: Sharepoint list 255 char limit with Multiple line of text

    If you have changed column setting to multiline text and still getting error in flow then remove Dynamic content or Expression where you are passing the value and add again.

     

    krishankumar_0-1631261462123.png

     

  • ToalaH Profile Picture
    4 on 16 Jul 2020 at 20:41:38
    Re: Sharepoint list 255 char limit with Multiple line of text

    I am having the same issue and want to try this fix. Just to be sure I understand, are you saying to delete the Create Item Action and add a new one with all the same settings as the previous?

  • efialttes Profile Picture
    14,756 on 27 Mar 2020 at 17:13:06
    Re: Sharepoint list 255 char limit with Multiple line of text

    HURRAY!

    IT WORKS!

     

    Thanx for marking this topic as "Solved" by clicking "Accept as a solution". This way other community members facing this same problem in the future have the chance to find a solution faster. 

    Thanx for your contribution to keep this community great!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,745 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,091 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow
Loading started
Loading complete