Using Compose with formatDateTime & utcNow

(0) Share

Report

Posted on by Power_Automater

351

I am using a Compose action to take a dynamic content date value (from a SP list):

And then I use this in a Create/Update Event action to set the start date with:

formatDateTime(outputs('Compose'),'yyyy-MM-ddTHH:mm:ss')

The problem is that the date and time I get in the Compose action is the incorrect timezone so by the time it is added into the event action it is wrong. Should I change what I put into the Compose action or update the expression used for start time, and if so how?

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Rhiassuring 8,692 Moderator on at

Like (2)

Report
Copy link

Link copied!

Hi there,

You can use the "convertTimeZone()" action in your compose, on your dynamic content. You might have something like convertTimeZone(yourfield,'UTC','Pacific Standard Time'). That should take care of it!

Was this reply helpful? Yes No
Power_Automater 351 on at

Like (0)

Report
Copy link

Link copied!

Thank you for that @Rhiassuring , so if I were to add the compose to this it would look like this?

convertTimeZone(outputs('Compose'),'UTC','Pacific Standard Time')

Also, where would I put the date format string part?

Was this reply helpful? Yes No
Rhiassuring 8,692 Moderator on at

Like (1)

Report
Copy link

Link copied!

You'd put it on the outside of that - like this:

formatdatetime(convertTimeZone(utcNow(),'UTC','Pacific Standard Time'),'yyyy-MM-dd')

(In my example I'm using utcNow() instad of a field, just to be clear)

Was this reply helpful? Yes No
Power_Automater 351 on at

Like (0)

Report
Copy link

Link copied!

So with the compose it would be like this?

formatdatetime(convertTimeZone(outputs('Compose'),'UTC','Pacific Standard Time'),'yyyy-MM-dd')

Was this reply helpful? Yes No
Verified answer

Rhiassuring 8,692 Moderator on at

Like (1)

Report
Copy link

Link copied!

You don't need to point at your Compose, you can call out your field. If you're going to use a field that will only have one output (like a single form response), it will look like this:

formatdatetime(convertTimeZone(outputs('Get_items')?['body/value'][0]?['Created'],'UTC','Pacific Standard Time'),'yyyy-MM-dd')

The [0] lets you get the only item in the array that is returned, since it's a single item. No need to go into an Apply to Each. And the ['Created'] is where you type whatever column you want.

If you are doing it in an Apply To Each (when there are multiple returns), it will look like this, inside of the Apply to Each:

formatdatetime(convertTimeZone(items('Apply_to_each')?['Created'],'UTC','Pacific Standard Time'),'yyyy-MM-dd')

Was this reply helpful? Yes No