Unanswered

output days error

Like (0) Share

Report

Posted on 22 Oct 2021 01:11:13 by Community Power Pla...

hi i created the schedule flow its show the output is okay last night, but i receive today email, which when i check the output for the day remains constant where it should be add 1 day after yesterday.

this is my flow, in the days column i use this formula :
div(sub(ticks(utcNow()), ticks(item()?['Created'])), 864000000000)

I have the same question (0)

All responses (4)

Answers (0)

VJR 7,635 on 22 Oct 2021 at 03:20:07

Like (0)

Report

Re: output days error

HI @Anonymous

Make sure both the time zones you are comparing are the same.
For eg you are using UtcNow in your function, but is the other date also in utc timezone?
Remember there is always a gap of few hours between utc and the time zone you would be in.

For eg; The current utc time as I write this post is 3:15 am
and time in IST timezone now is 8:45 am.

The point is, the day(or date) may have changed in a "particular timezone" but it is still the previous day in utc, because of the gap in hours of this "particular timezone" and utc.

Was this reply helpful? Yes No
CFernandes 8,396 Most Valuable Professional on 22 Oct 2021 at 04:34:05

Like (0)

Report

Re: output days error

Hey @Anonymous

You will need to convert the timezone and then pass it to your "Select" action.

To Convert the timezone you can use -

Formula --

convertTimeZone(timestamp: string, sourceTimeZone: string, destinationTimeZone: string, format?: string)

For details see - https://support.microsoft.com/en-us/topic/converting-time-zone-in-microsoft-power-automate-8bce2441-1859-4d76-2f51-985d9c96534d

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
Community Power Pla... on 22 Oct 2021 at 05:04:22

Like (0)

Report

Re: output days error

data source is same as my time zone, example created date 13/10/2021 . so i need to change the time zone again?

Was this reply helpful? Yes No
Community Power Pla... on 22 Oct 2021 at 06:56:32

Like (0)

Report

Re: output days error

its show an error after i put in the "select" action.
i change the formula :
div(sub(ticks(body('Convert_time_zone'))), ticks(item()?['Created'])), 864000000000)

Was this reply helpful? Yes No