Flow not working correctly String was not recognized as a valid DateTime.

(0) Share

Report

Posted on by NiallOB01

Hi, I am getting the below error message stopping my flow from running.

String was not recognized as a valid DateTime. And then my Client ID.

I am running an export from Excel to Outlook Calendar event.

Below is my excel headers

And this is the config for the Outlook Event

Help please??

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

emadrigal Microsoft Employee on at

Like (0)

Report
Hello @NiallOB01

I think you're getting this error because your Date field in excel is not in the ISO format. You can try changing this to the correct format.
Instead of using 'dd-MM-yyyy' you should use 'yyyy-MM-dd'

To be able to change the format in excel you can review Creating a custom date format in Excel in this link: How to change Excel date format and create custom formatting (ablebits.com)

Other option is using the FormatDateTime() in Power Automate to format your date in different date formats like dd/MM/yyyy, MM/dd/yyyy. For that you should use this function:

formatDateTime(variables('VariableName'),'dd-MM-yyyy')

Links to learn more about FormatDateTIme function:
Power Automate formatdatetime [with real examples] - SPGuides
Power Automate Fundamentals # 5: Usage of formatDa... - Power Platform Community (microsoft.com)

Other option is doing something like this:

Let me know if it this helps you!

Regards,

Community Support Team - Edgar Madrigal
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
NiallOB01 18 on at

Like (0)

Report

Okay so I got that part working, and it succeeds, however it doesnt actually post anything to my outlook? Any ideas with the same configuration

Was this reply helpful? Yes No
emadrigal Microsoft Employee on at

Like (0)

Report

Hello @NiallOB01

Could you please send more pictures about your complete flow to see more details about it. To see what trigger you are using.

Regards,

Community Support Team - Edgar Madrigal

Was this reply helpful? Yes No