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

I have the same question (0)

All responses (6)

Answers (1)

ChristianAbata 8,951 Most Valuable Professional on at

Like (1)

Report

Re: Problem with date formation

hi pleasee @ZowieS see this, you need to change in expressions part, to add the fuction.

Was this reply helpful? Yes No
MJain 2,450 on at

Like (1)

Report

Re: Problem with date formation

Hi @ZowieS ,

use your formula in expression part.

Was this reply helpful? Yes No
ZowieS 124 on at

Like (0)

Report

Re: Problem with date formation

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:

Was this reply helpful? Yes No
RobElliott 10,313 Super User 2025 Season 2 on at

Like (2)

Report

Re: Problem with date formation

@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.

Was this reply helpful? Yes No
ZowieS 124 on at

Like (0)

Report

Re: Problem with date formation

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

Was this reply helpful? Yes No
Verified answer

ZowieS 124 on at

Like (0)

Report

Re: Problem with date formation

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')

Was this reply helpful? Yes No