News and Announcements icon

Power Platform CommunityForums Power Automate - Using Flows Flow not working corre...

Power Automate - Using Flows

Answered

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

(0) Share

Report

Report

Posted on by NiallOB01

18

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??

All responses Img

All responses (3)

Answers Img

Answers (1)

emadrigal Microsoft Employee on at

Like (0)

Report

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

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
NiallOB01 18 on at

Like (0)

Report

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

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
Verified answer

emadrigal Microsoft Employee on at

Like (0)

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

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.

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Replay: Power Platform Community AMA - Copilot Studio | April

Welcome to the Power Platform Communities

Quick Links

Leaderboard

#1

WarrenBelz 146,601 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 65,946 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans