Skip to main content

Notifications

Community site session details

Community site session details

Session Id : Ph+o6JPsps7Kq0HYaMyYka
Power Automate - General Discussion
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) ShareShare
ReportReport
Posted on 25 Jun 2019 22:27:39 by 15

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.2019-06-25_16-05-07.png

 

  • v-yamao-msft Profile Picture
    on 01 Jul 2019 at 09:02:29
    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

     

  • yashag2255 Profile Picture
    24,442 Super User 2024 Season 1 on 27 Jun 2019 at 16:53:02
    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!

  • Verified answer
    buddhasbuddy Profile Picture
    15 on 27 Jun 2019 at 16:06:52
    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.

  • v-yamao-msft Profile Picture
    on 26 Jun 2019 at 09:10:53
    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

     

  • yashag2255 Profile Picture
    24,442 Super User 2024 Season 1 on 26 Jun 2019 at 06:47:29
    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.

  • buddhasbuddy Profile Picture
    15 on 26 Jun 2019 at 04:39:31
    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.

    image.png

    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.

     

  • yashag2255 Profile Picture
    24,442 Super User 2024 Season 1 on 26 Jun 2019 at 03:37:19
    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)timwa.png

     

    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!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,743 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,089 Most Valuable Professional

Leaderboard