Answered

Status 400 Error Message: The string was not recognized as a valid DateTime. There is an unknown word starting at index 0

Like (0) Share

Report

Posted on 25 Jun 2019 22:27:39 by buddhasbuddy

I have created a flow that pulls Item data from one list (inlcuidng attachments) and puts in another. All of a sudden I get a Status 400 error and the message: 'The string was not recognized as a valid DateTime. There is an unknown word starting at index 0.' The error occurs at the create item level.

What is causing this error and how do I repair it.

I have the same question (0)

All responses (7)

Answers (1)

v-yamao-msft on 01 Jul 2019 at 09:02:29

Like (0)

Report

Re: Status 400 Error Message: The string was not recognized as a valid DateTime. There is an unknown word starting at index 0

Hi @buddhasbuddy ,

Thanks for updating.

Best regards,

Mabel

Was this reply helpful? Yes No
yashag2255 24,695 Super User 2024 Season 1 on 27 Jun 2019 at 16:53:02

Like (0)

Report

Re: Status 400 Error Message: The string was not recognized as a valid DateTime. There is an unknown word starting at index 0

Hi @buddhasbuddy

Glad that it worked!

If your question/query is resolved, please mark the response that best helped you as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Verified answer

buddhasbuddy 15 on 27 Jun 2019 at 16:06:52

Like (0)

Report

Re: Status 400 Error Message: The string was not recognized as a valid DateTime. There is an unknown word starting at index 0

@v-yamao-msft @yashag2255 Thank you for your time on this issue. I determined it had nothing to do with the DueDate field. I believe the issue stemmed from trying to pass the 'Created By' claim for the 1st list to the Requestor (people) field in the second. When I deleted the requestor field the Flow worked again.

Thanks again.

Was this reply helpful? Yes No
v-yamao-msft on 26 Jun 2019 at 09:10:53

Like (0)

Report

Re: Status 400 Error Message: The string was not recognized as a valid DateTime. There is an unknown word starting at index 0

Hi @buddhasbuddy ,

It seems that the error occurs on action Create item.

In action Create item, there is a date and time column DueDate, which is using a dynamic content DueDate from the trigger.

Have you made any changes on the list?

Please try using a formatDateTime function to format the return value of DueDate to a valid format to see if it will work.

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#formatDateTime

Best regards,

Mabel

Was this reply helpful? Yes No
yashag2255 24,695 Super User 2024 Season 1 on 26 Jun 2019 at 06:47:29

Like (0)

Report

Re: Status 400 Error Message: The string was not recognized as a valid DateTime. There is an unknown word starting at index 0

@buddhasbuddy

Can you please initialise a variable before create item (the type should be string) and the value is the date option from the get item actions' dynamic option selector tab. Run the flow and see what value you are getting in there and please post a screenshot here so that we can assist you better.

Was this reply helpful? Yes No
buddhasbuddy 15 on 26 Jun 2019 at 04:39:31

Like (0)

Report

Re: Status 400 Error Message: The string was not recognized as a valid DateTime. There is an unknown word starting at index 0

Unfortunately no, the error is generated as it creates the item.
The function you see in my email is a ConvertfromUTC function based on the 'Created By' fielf of the first list. EVerything in this flow ran successfully up to today.

Was this reply helpful? Yes No
yashag2255 24,695 Super User 2024 Season 1 on 26 Jun 2019 at 03:37:19

Like (0)

Report

Re: Status 400 Error Message: The string was not recognized as a valid DateTime. There is an unknown word starting at index 0

Hi @buddhasbuddy

Can you post a screenshot of the error that is coming in? I am guessing it is at the end on the send email action. Can you post the expression that you are using?

TO convert timezone, I would suggest you to use the Convert time action (see the screeshot below)

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No