Answered

How to convert the Full date/time pattern short time (Monday, June 15, 2009, 1:45 PM) to 2009-06-15T13:45:30 in power automate? I will have the Full date/time pattern short time (Monday, June 15, 2009, 1:45 PM) in Excel sheet

(0) Share

Report

Posted on by Kowshik

How to convert the Full date/time pattern short time (Monday, June 15, 2009, 1:45 PM) to 2009-06-15T13:45:30 in power automate? I will have entries of Full date/time pattern short time (Monday, June 15, 2009, 1:45 PM) in a column of an excel sheet. My main objective is to create event V4, scheduling a calendar meeting in outlook using Monday, June 15, 2009, 1:45 PM date/time format. Could someone please assist.

Thanks in advance!!

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Kowshik

Give parsedatetime a go. Reference guide for expression functions - Azure Logic Apps | Microsoft Docs

parseDateTime(outputs('Compose'),'en-US')

Cheers
Damien

Please take a look and subscribe to my YouTube Channel for more Power Platform ideas and concepts. Thanks

Was this reply helpful? Yes No
Kowshik 8 on at

Like (0)

Report
Copy link

Link copied!

Hi Damien,
Your suggested solution worked. Thank you!!

Was this reply helpful? Yes No