Unanswered

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

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (1)

Report

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?

Was this reply helpful? Yes No
darshanas 7 on at

Like (0)

Report

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 🙂

Was this reply helpful? Yes No
shreyamalik123 2 on at

Like (0)

Report

@darshanas which settings did you change

Was this reply helpful? Yes No