Unanswered

output days error

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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)

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

VJR 7,635 on at

Like (0)

Report
Copy link

Link copied!

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,504 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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