approval flow - time is an hour out

(0) Share

Report

Posted on by AB21

Hi all,

I have a flow that uses approvals that is linked to a sharepoint list.

Screenshot 2020-03-09 at 12.37.02 PM.png

the convert formula I use is

convertTimeZone(utcnow(triggerBody()?['StartDate']),'UTC','W. Europe Standard Time','dd/MM/yyyy HH:mm')

This works but when the email is sent to the person it needs to be sent too, the time is one hour forward

Screenshot 2020-03-09 at 12.41.16 PM.png

Screenshot 2020-03-09 at 12.15.16 PM.png

Thanks in advance

Categories:

Building flows

I have the same question (0)

All responses (15)

Answers (0)

Jcook 7,781 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hello,

Try using the date time action to convert time zone.

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

Was this reply helpful? Yes No
AB21 on at

Like (0)

Report
Copy link

Link copied!

Sorry how do I do this?

Was this reply helpful? Yes No
AB21 on at

Like (0)

Report
Copy link

Link copied!

Hi @Jcook ,

Im pretty new to automate can you please explain on how I do this please?

Thanks in advance,

Was this reply helpful? Yes No
Jcook 7,781 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hello @AB21
Could you provide me with the date time that you are trying to convert?

I am asking for a sample date time to confirm my method will work.

Thanks

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

Was this reply helpful? Yes No
AB21 on at

Like (0)

Report
Copy link

Link copied!

Hi @Jcook

the date and time is coming from a sharepoint list.

if the date and time is inputted like so in the approval email the time is a hour forward. The date is correct.

Formula used: convertTimeZone(utcnow(triggerBody()?['StartDate']),'UTC','W. Europe Standard Time','dd/MM/yyyy HH:mm')

Changing StartDate to EndDate for the end time/date

Was this reply helpful? Yes No
Jcook 7,781 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hello @AB21

This is most likely due to Daylight savings time?

My suggestions would be to use a addHours() expression.

Example:

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

Was this reply helpful? Yes No
AB21 on at

Like (0)

Report
Copy link

Link copied!

Hi @Jcook ,

Am I doing something wrong?

I cant seem to get this to work I get an error, here is my flow:

Here is the error:

Thanks in advance

Was this reply helpful? Yes No
Jcook 7,781 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @AB21

So you are using my expression exactly.

Change your expression to:

addHours(outputs('Compose'),-1)

You were referencing my compose shape, as my shape was named Compose Start Date.
Yours is just Compose. So you only need to reference your shape's name

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

Was this reply helpful? Yes No
DanyElHoyek 91 on at

Like (0)

Report
Copy link

Link copied!

Did you try to convert the Date / Time by using the action "Convert time zone" instead of using the expression formula?

Was this reply helpful? Yes No
AB21 on at

Like (0)

Report
Copy link

Link copied!

Hi @DanyElHoyek

How do I do this?

Was this reply helpful? Yes No