cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User
Super User

Debugging: "status": 400, ...

Hello, 

 

I have a Flow that intermittently fails (4-5 instances over the past 3 months) at "Update File Properties" with a "Bad Request" heading.

 

  • Here is a snapshot of the steps:

2018-09-13_11-04-37.png

Here is the Status 400 error message at the bottom of Update File Properties: 

 

{
  "status": 400,
  "message": "Invalid text value.\n\nA text field contains invalid data. Please check the value and try again.\r\nclientRequestId: 24d0ed01-1950-4c63-8d47-f6e2ae5026c6\r\nserviceRequestId: bc268e9e-c008-7000-51f9-7f06ae770f58"
}

Unfortunately, I don't know which Text Field has contains the invalid data! 

  • The fields are not clearly listed in the error message
  • Nor is there an indicator on any of the fields that it contains invalid data

 

How do I debug the issue here? 

 

Thank you

6 REPLIES 6
Highlighted
Community Support
Community Support

Re: Debugging: "status": 400, ...

Hi @ericonline,

 

Could you share the detailed screenshot of your flow configuration? What properties are you going to update?

 

I made a simple test with the similar configuration. However, it ran succeed.

1.PNG

 

Could you share more details to help reproduce it on my side?

 

Best regards,

Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Super User
Super User

Re: Debugging: "status": 400, ...

Hello @v-yamao-msft

 

Below is a detailed screenshot of the Flow. The properties I'm updating are items in a Word template. The Flow runs all the time without issue. It only fails intermittently. 

 

Ideally, I'd like to know HOW to debug this error. 

 

Thank you

 

flowTroubleshooting.png

Highlighted
Community Support
Community Support

Re: Debugging: "status": 400, ...

Hi @ericonline,

 

What are the column types you are going to update?

 

Do you have a Multiple lines of text column? If the character length exceeds the limit, the flow will return the error message.

 

 

Best regards,

Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Super User
Super User

Re: Debugging: "status": 400, ...

Thank you for the response @v-yamao-msft. Is there anyway to determine WHICH field has the issue? As you can see there are 30-40 fields. Would love to have the error point me diretly to the field in question. 

Highlighted
Anonymous
Not applicable

Re: Debugging: "status": 400, ...

Hello,

 

 

I have a similar problem, could you help us to know which column have the error and the limit of caracter for a individual column? . @ v-yamao-msft.

 

 

Thz

Highlighted
New Member

Re: Debugging: "status": 400, ...

I agree - I have a document with 65 fields being updated. Just being told one of them has a problem without being able to debug which one it is is frustrating...  Suspect it may be do to with column length  as others have suggested but I am going to have to go through all 65 to check!!  woudl be useful if the error message could identify which field has the problem 🙂

Helpful resources

Announcements
secondImage

August 2020 CYST Winners!

Check out the winners of the recent 'Can You Solve These?' community challenge!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Users online (4,258)