Unanswered

maximum field length

(0) Share

Report

Posted on by kmaclean

I have a flow that has "failed" The error message says this:

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

I can see the submission that a participant has made. I was thinking I could either just delete a few of the words to make the submission shorter, or make the field length longer. But I can't figure out how to do either of those. Could anyone help me? Thanks!

Categories:

General topics

All responses (13)

Answers (0)

Sort by

yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

Hey @kmaclean

Can you share more details on the scenario that you are trying to build? Maybe a screenshot of the flow?

Note: I can see that it is a sharepoint create item action where you are trying to populate a Single Line of Text/ URL type of field and these currently limit the number of characters to 255.

In such a case, you can probably use the substring(sourcestring, 0, 255) to get the first 255 characters of the string and use that to reference the field.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
kmaclean 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for the response. I am not sure how to do this though! Where would I type this in? Thank you!

"In such a case, you can probably use the substring(sourcestring, 0, 255) to get the first 255 characters of the string and use that to reference the field."
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(3)

Report
Copy link

Link copied!

Hey @kmaclean

You can refer to the below sample:

Expression:

if(lessOrEquals(length(variables('dd')),255),variables('dd'),substring(variables('dd'),0,255))

This checks the length of the variable dd and if less than or equal to 255, use as is or else create a sub string with first 255 chars.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
PCKeith 6 on at

Like
a
(2)

Report
Copy link

Link copied!

My solution was to just change the columns in my SharePoint list from "Single line of text" to "Multiple lines of text". My flow started working perfectly even with very long answers
yabela 53 on at

Like
a
(2)

Report
Copy link

Link copied!

Hello, what if I do not want to create a substring of the original string and I want to keep all of it? In my case, I have a field called FileURL and I was getting an error that I was trying to input 130 characters while the field had a max. character size of 100. I went to my table, changed the maximum size of the field to 500, published the changes, and tried to run the flow again but it still fails with the same error.

Any ideas on how I can fix this, please?
ChuckN 5 on at

Like
a
(1)

Report
Copy link

Link copied!

The same issue. The SP field is already multiple line type and target table column is varchar(max) and still getting the error.
MS need to fix this.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

This did the trick for me, too!
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Have you re-tried? for me it did the trick, but not immediately, apparently it takes some action (hard refresh?) or time lapse to update the schema before the connector realizes it can now write more than 255 chars in that column.
Community Power Pla... Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!

Good point @Anonymous, many times you have made several changes to a flow or list and have no way of knowing whether or not you have solved the problem because testing it still shows an error. But waiting often resolves the problem. This is far from ideal in a production setting because it makes it extremely difficult to troubleshoot issues. Just had the same happen to me.
victoraguiar 43 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello there. I have the same issue but I am importing the data from Smartsheet, did a ParseJson and want to upload a field in SQL Database. The field was originally varchar(255) and I changed to varchar(MAX). Nevertheless, it still fails. Thank you!