Problem with date formation

(0) Share

Report

Posted on by ZowieS

124

Hi,

I'm trying to create All day events in a calendar with Create Event (V4) and the format it wants is "yyyy-MM-ddThh:mm:ss"

2020-04-23 14_03_49-Edit your flow _ Power Automate.png

I've been trying to format the date but I'm unsuccessful.

I've been trying:

@formatdatetimetriggerBody()?['FromDate'],'yyyy-MM-ddThh:mm:ss')
formatdatetime(triggerBody()?['FromDate'],'yyyy-MM-ddThh:mm:ss')
"@formatdatetime(triggerBody()?['FromDate'],'yyyy-MM-ddThh:mm:ss')"
"formatdatetime(triggerBody()?['FromDate'],'yyyy-MM-ddThh:mm:ss')"
@formatdatetime(outputs['FromDate'],'yyyy-MM-ddThh:mm:ss')

This is how it's now:

2020-04-23 15_13_28-Edit your flow _ Power Automate.png

And the result is:

2020-04-23 15_13_20-Run History _ Power Automate.png

Is my formatting wrong or do I need to use "addMinutes" or something?

Or perhaps both?

Thank you!

Categories:

Building flows

All responses (6)

Answers (1)

Sort by

ChristianAbata 8,953 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

hi pleasee @ZowieS see this, you need to change in expressions part, to add the fuction.
MJain 2,450 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @ZowieS ,

use your formula in expression part.
ZowieS 124 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ManishJain and @ChristianAbata,

Thank you for your help!

I've tried that but that didn't work.

The Expression is: formatdatetime(triggerBody()?['FromDate'],'yyyy-MM-ddThh:mm:ss')
And the result was:

Also, the FromDate is from a Sharepoint list and the column typ is Date and Time:
RobElliott 10,543 Super User 2026 Season 2 on at

Like
a
(2)

Report
Copy link

Link copied!

@ZowieS one thing to remember is that the case inside the expression needs to be correct. You've got formatdatetime all in lower case whereas it should be formatDateTime.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.
ZowieS 124 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RobElliott,

Ah, didn't know it was case sensitive in the Expression.
But sadly it still didn't work

Do I need to convert the date to string first and then convert it back to date for the Create Event (V4)?
Verified answer

ZowieS 124 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

I've solved it. 😁
I didn't know that you need/could to go back and fourth between Dynamic content and Expression.
So I did as in this video but with Compose.

Thank you for you help @RobElliott, @ManishJain & @ChristianAbata!

The solution:
Expression:
formatDateTime(outputs('Create_item_from_the_MS_Form_response')?['body/FromDate'],'yyyy-MM-ddThh:mm:ss')