Emails to Share point List and receiving error

(0) Share

Report

Posted on by chucksta

I have created a SHarepoint List for some service emails.

When i try to test the actions on an email that is sent to my email address I am getting the error below:

Body

{
"status": 400,
"message": "Invalid text value.\n\nA text field contains invalid data. Please check the value and try again.\r\nclientRequestId: 22f9b463-b061-42ea-85d5-9d5e188dfd22\r\nserviceRequestId: b9188e9e-60dc-6000-eaa8-d1eca77ecc8c"

Not sure what this error stems from or why I am getting it. I have no problem when I leave the body off the flow, but not srue why the flow is not working. I have even tried just an email with Test in the body and I get this failure. Thanks in adnave for your assistance!

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @chucksta,

Have you checked whether the content of your Email Body output matches the type of the field corresponding to the SP list?

The Email Body output is generally in Html format, you need to convert it to Text format.

I have made a test on my side and the flow works well. Please take a try with the following workaround:

Image reference:

The flow works successfully as below:

Please take a try and let me know if issue still exist.

Best Regards,
Barry

Was this reply helpful? Yes No
chucksta on at

Like (0)

Report
Copy link

Link copied!

Trying shortly and will update.

Was this reply helpful? Yes No
chucksta on at

Like (0)

Report
Copy link

Link copied!

@v-bacao-msft

I still get the same error I think its becasue the email that I am trying to import into the body column of the sharepoint list has over 300 characters and I am wondeirng if that is the problem. Now would there be a way to either get this data to import into the field or make the data accessible but smaller?

Was this reply helpful? Yes No
chucksta on at

Like (0)

Report
Copy link

Link copied!

I got it to work. My list setup as single line. I made it mulitple for the body column and it works, just trying to figure out how to remove the word wrap from the body column so it wont be so big. any suggestions?

Was this reply helpful? Yes No