Maximum String Length Issue

David Levick 0 Reputation points
2024-09-09T15:08:29.0533333+00:00

Hi,

I have a form that feeds into Microsoft Lists, the form is setup with a multi line field, I have tried the method of changing a single line to a multiline and removing and re-adding the flow but im not having any luck - I get the following.

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

Any help would be greatly appreciated, iv tried looking and there are a lot of articles on it but nothing iv tried is working.

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,675 questions
SharePoint Workflow
SharePoint Workflow
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Workflow: An orchestrated and repeatable pattern of business activity, enabling data transformation, service provision, and information retrieval.
583 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Yanli Jiang - MSFT 26,016 Reputation points Microsoft Vendor
    2024-09-10T07:19:09.86+00:00

    Hi @David Levick ,

    Welcome to Q&A forum!

    It looks like you've already taken steps, but with no luck. I suggest you try the following to see if it helps:

    Here are a few suggestions to help you solve this problem:

    1. Ensure the Field is Multi-Line Text in Microsoft Lists:
    • Double-check that the field in Microsoft Lists is set as a multi-line text field and not a single-line text field. Sometimes it might look like it’s set correctly but may need a reconfiguration.
    • Go to your list settings, find the column in question, and ensure it’s set to "Multiple lines of text". And if your multi-line text field is set to rich text, try changing it to plain text. Rich text fields can sometimes cause issues with character limits.
    1. Update Your Power Automate Flow:
    • Remove the existing connection to the column in your flow.
    • Re-add the connection to ensure that it recognizes the field as multi-line text.
    • Check the dynamic content in your flow to see if the field is showing as text or multi-line text.
    1. Truncate Input String (as a temporary workaround):
    • If the multi-line text field still doesn't recognize the extended length, you might consider truncating the input string to 255 characters temporarily and then addressing the underlying issue.
    • You can use an expression in Power Automate to set a substring for the field in question. - Use the expression: substring(triggerBody()?['Your_Field_Name'],0,255)
    1. Use REST API:

    Hope this can help!

    Good day!


    If the answer is helpful, please click "Accept as Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


  2. Yanli Jiang - MSFT 26,016 Reputation points Microsoft Vendor
    2024-09-26T07:16:51.5133333+00:00

    Hi @David Levick ,

    We haven't heard from you in a while and don't know how the issue is progressing. I have done further research on this matter, but unfortunately, the available information is limited.

    To help you better, we recommend you directly create a support ticket from Microsoft 365 Admin.

    The support team over there has the correct escalation channel, they can involve more resource and investigate the behavior from back end as fast as possible. They also can check the behavior on your end remotely. For reference: Get support - Microsoft 365 admin | Microsoft Docs, you can select online support or phone support to have a live chat with the support engineers.  This is the most efficient way for handling this thread as per the situation.

    Good day!


    If the answer is helpful, please click "Accept as Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.