The API operation 'PostItem' requires the property 'item/emailaddress1' to be a string of maximum length '100' but is of length '101'

(0) Share

Report

Posted on by XeXE

132

Hello,

I'm getting an error here sometimes and sometimes not:

//The 'inputs.parameters' of workflow operation 'Create_a_new_record_(deprecated)' of type 'OpenApiConnection' is not valid. Error details: The API operation 'PostItem' requires the property 'item/emailaddress1' to be a string of maximum length '100' but is of length '101'.//

Web capture_8-12-2022_133215_make.powerautomate.com.jpeg

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Expiscornovus 33,995 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @zerou,

It looks like you are using the Dynamics 365 connector with the Create a new record (deprecated) action, correct?

If that is the case you are using a connector (Dynamics 365) which has been deprecated a while ago (05 May 2020):

https://learn.microsoft.com/en-us/power-platform/important-changes-coming#dynamics-365-connector-is-deprecated

Is there a reason why you are not using the Dataverse connector and the Add new row action instead?

Was this reply helpful? Yes No
Matthy79 4,188 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Deprecated connector aside. If you try to store information and exceed the limit you will get a similar error when using a different connector. It looks like "emailaddress1" is set to a maximum of 100 characters and the email adress you are trying to save (sometimes) is larger than 100 characters. In this case 101. Try to add a compose action in front of the action that fails and print the email adress.

Was this reply helpful? Yes No
XeXE 132 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi guys I updated the flow but it's still failing. I'm not sure how to add the compose field in this case:
email field :

Was this reply helpful? Yes No
Verified answer

Matthy79 4,188 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @zerou

What is the error message? Is it still that the email adress is longer than the field length you want to store it in?

To add the compose field you just need to put the same formular as in the email-field you want to store in the compose action (in front of the failing step). After the flow run you will see the value you want to store in the compose action output.

Was this reply helpful? Yes No
XeXE 132 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, it's the same email string is too long message. I took a look at the outputs from a failed flow, and it seems to be capturing all the data sent into the form and treating it as an email, instead of just the email field.

For what you're suggesting, are you saying I add a compose action in front of "add a new row" and out in the forumla that I'm using in the email field?

first(skip(split(first(split(body('Html_to_text'),'Phone')),'Email:'),1))

Was this reply helpful? Yes No
Matthy79 4,188 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, that is what I meant but you already noticed that the value you are trying to store is not correct so you need to modify the formular to get the correct email. Maybe you try the same thing with the other fields too because it looks like you are using similar formulars for all the fields.

Was this reply helpful? Yes No
XeXE 132 on at

Like
a
(0)

Report
Copy link

Link copied!

I was able to fix it by changing the formula for email to :

first(split(last(split(outputs('Html_to_text')?['body'],'Email:')),'Topic'))

Thanks !

Was this reply helpful? Yes No
XeXE 132 on at

Like
a
(0)

Report
Copy link

Link copied!

*Sigh* So the problem has returned, the email step is still complaining about the string length. I added the compose function as well with the same formula as in the email expression, but it's returning the email *and* other text typed in, hence the string error.

Update: Went back to the old formula: //first(skip(split(first(split(body('Html_to_text'),'Phone')),'Email:'),1))//
And put that in the compose step instead, now it's working...for now.

Was this reply helpful? Yes No