Unanswered

Scheduled Flow comparing dates - next day triggered early

(0) Share

Report

Posted on by dhol

Hi. I have a Flow which is scheduled to run at 9.59pm which updates a List column called 'Today's Date' and then compares the date entry in another column with this date and if they are the same it sends an email. No matter what I do with the scheduling options (time zones etc) the next day date is shown in the Flow output six hours before the next day actually arrives. This means no email is sent at 9.59pm because the Flow seems to regard the columns as not matching. Though this happens, the actual 'Today's date' column in the List is only updated at midnight, correctly as you would expect. Any help with this would be much appreciated.

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

Mira Ghaly 11,413 Moderator on at

Like (0)

Report

Re: Scheduled Flow comparing dates - next day triggered early

Hi @dhol
Try to change the format of the 2 dates you are comparing before the comparison to Date Only,
formatDateTime(utcNow(),'dd/MM/yyyy')

If this solves your problem please mark as Accepted solution.

Was this reply helpful? Yes No
v-alzhan-msft on at

Like (0)

Report

Re: Scheduled Flow comparing dates - next day triggered early

Hi @dhol ,

What's your time zone?

You said your flow would always run 6 hours early, have you take a try to set the time zone in the trigger?

Could you please share the screenshot of the flow?

I have made a test on my side and the trigger would works for a selected time zone:

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
dhol 6 on at

Like (0)

Report

Re: Scheduled Flow comparing dates - next day triggered early

Hi Alice. The flow does not run early, it runs as scheduled and it always runs successfully. However, the Output from Get items seems to show the flow seeing the next day before it has arrived - see below: flow ruin on 22 July but today's date showing 23 July. This happens from 6.00pm (my time)

Was this reply helpful? Yes No
v-alzhan-msft on at

Like (0)

Report

Re: Scheduled Flow comparing dates - next day triggered early

Hi @dhol ,

That is cause by the time in flow are always UTC time.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
dhol 6 on at

Like (0)

Report

Re: Scheduled Flow comparing dates - next day triggered early

Thanks Alice. Do you know why then it 'failing' six hours early - my understanding is that in the United Kingdom I am ahead (not behind) UTC, and then only by one hour? Thanks.

Was this reply helpful? Yes No
v-alzhan-msft on at

Like (0)

Report

Re: Scheduled Flow comparing dates - next day triggered early

Hi @dhol ,

Please share the screenshot of the flow and the run history so we could better understand you and provide the workaround.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
dhol 6 on at

Like (0)

Report

Re: Scheduled Flow comparing dates - next day triggered early

Hello Alice. Here is the Flow and History:
Top left - Flow Top right - Apply to each Bottom- Condition

Was this reply helpful? Yes No