Unanswered

output days error

(0) Share

Report

Posted on 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)

All responses (4)

Answers (0)

Community Power Pla... on at

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)
Community Power Pla... on at

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?
CFernandes 8,283 Most Valuable Professional on at

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.
VJR 7,635 on at

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.