Answered

String of maximum length '100' but is of length '1092'

(0) Share

Report

Posted on by darshanas

Hi, I'm getting the following error when using my Power Automate flow.

"The 'inputs.parameters' of workflow operation 'Insert_row_(V2)_2' of type 'OpenApiConnection' is not valid. Error details: The API operation 'PostItem_V2' requires the property 'item/Comments_x0020_and_x0020_Work_x0020_Notes' to be a string of maximum length '100' but is of length '1092'."

Is there a way to solve this issue? I'm trying to get fields such as Work Notes, Additional Comments, etc. from ServiceNow that have lines of text. I would like to get all of that information but the error says that the maximum length is 100 only. How can I increase this length to 1092 or more?

Any help/suggestions appreciated.

Thanks,

Darshana

All responses (3)

Answers (1)

shreyamalik123 2 on at

Like (0)

Report

Re: String of maximum length '100' but is of length '1092'

@darshanas which settings did you change
darshanas 7 on at

Like (0)

Report

Re: String of maximum length '100' but is of length '1092'

Yes @Expiscornovus , you're right. That's what I did - I changed the storage settings in my SQL database and the flow works now.

Thank you 🙂
Verified answer

Expiscornovus 31,635 Most Valuable Professional on at

Like (1)

Report

Re: String of maximum length '100' but is of length '1092'

Hi @darshanas,

The error suggests that you are using the SQL Connector action, insert row (V2): https://docs.microsoft.com/en-us/connectors/sql/#insert-row-(v2)

Is that correct, are you trying to insert rows into a SQL database via Power Automate?

In that case can't you change the settings in your SQL database?