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
Thanks! It worked fine and quickly
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!!
This worked perfectly for me, and was very quick! Thanks so much.
this solution solved my problem real quick. cheers!!
Awesome, this worked! Thank you!
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!
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
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.
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?
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!
WarrenBelz
146,745
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional