Sharepoint list 255 char limit with Multiple line of text

[Treawlony]

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

[efialttes · Accepted solution]

Hi!

Two suggestions:

-remove 'Create item' and add a new one

-go to Sharepoint List - config column and share a screenshot with current settings

Thanx!

[Treawlony]

Hi, screenshot here, meanwhile I'll try the first one

Thanks

Carlo

[Treawlony]

oh my... I had to recreate the item creation and it worked... spent 4 hours on this... thanks mate!

[efialttes]

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!

[ToalaH]

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?

[krishankumar]

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.

[simondoy]

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

[Cassie_Price]

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!

[jrm315]

Awesome, this worked! Thank you!

[Kwad1z]

this solution solved my problem real quick. cheers!!

[c_tepe]

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

[Susan_D]

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!!

[WillianSantos]

Thanks! It worked fine and quickly