Maximum String Length Issue

Question

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.

Answer 1

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.

2. 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.

3. 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)

4. Use REST API:

• For your reference:
• https://learn.microsoft.com/en-us/answers/questions/1027408/the-api-operation-postitem-requires-the-property-i

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.

Answer 2

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.