Flow failing due to string not recognizing valid DateTime

(0) Share

Report

Posted on by bscarpelli

Hi all,

My flow is failing and I am not sure what is the cause.

Error message is:

String was not recognized as a valid DateTime.
clientRequestId: f5043bb8-e80c-4c1f-8add-01da94f19de0
serviceRequestId: f5043bb8-e80c-4c1f-8add-01da94f19de0

Flow with errors:

View of the complete flow:

Any suggestions?

Thank you so much!

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

Re: Flow failing due to string not recognizing valid DateTime

Hi @bscarpelli

Assuming your sharepoint list item data type is date, you would need to format the string returned by the form into a valid date format. This can be achieved using formatdatetime(formvalue,'yyyy-MM-dd'). Take a look here FormatDateTime and Formatting a String Date - DamoBird365 for a better understanding of date/time formatting.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉

Was this reply helpful? Yes No
bscarpelli 10 on at

Like (0)

Report

Re: Flow failing due to string not recognizing valid DateTime

One issue I am having is difficulty seeing which item is causing the issue. I have several items and some are dates and others are not. And advice on how I can determine which part of the flow is causing the issue?

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

Re: Flow failing due to string not recognizing valid DateTime

hi @bscarpelli

Are you using a date picker? I would assume all, albeit I haven’t tried this myself. Best remove the dates from the create item and get it working, then add one date and fix the formatting and then fix the others.

Damien

Was this reply helpful? Yes No
bscarpelli 10 on at

Like (0)

Report

Re: Flow failing due to string not recognizing valid DateTime

I think I might just have to scratch the whole idea - a bit too complicated for me and I already spent HOURS working on this flow to get the form submission to create a sharepoint item then send email confirmation to the provider of their scheduled training. If I remove the items now it may cause issues with the confirmation email being sent and I don't want to break anything else. Currently the form has a date selector and the sharepoint items that are being created also have date as the type of data that match so not a whole lot more I can do.

Thank you so much for your help!

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

Re: Flow failing due to string not recognizing valid DateTime

If you give me a few hours or so, I will create the same and give you a definitive answer.

Damien

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

Re: Flow failing due to string not recognizing valid DateTime

Hi @bscarpelli

My form accepts date in format dd/MM/yyyy as I am UK.

Out of the box, the date picker to a List Item works fine where the data type is both date and date/time without any conversions required. It converts from dd/MM/yyyy to yyyy-MM-dd.

Having looked again at your flow, onboarding date and time onboarding is based on two dynamic values? Are these date columns? What is the expected input and output?

Damien

Was this reply helpful? Yes No