Having trouble with getting today's date for a condition

(0) Share

Report

Posted on by spinneroo

242

Hello

My Flow depends on a column (Future Approval Date) equals Today. I live in Australia so date format is dd/MM/yyyy

What I have so far is if 'Future Approval Date' is equal to formatDateTime(utcNow(),'ddMMyyyy') (which needs to be Today) then proceed.

I've tried just utcNow() and put in a convert time zone as well and that doesn't work either.

Not sure if convert time zone is necessary but I've been battling with this for a long time. Flow just goes down the No side and doesn't work.

Categories:

Building flows

I have the same question (0)

All responses (16)

Answers (1)

Gristy 2,429 on at

Like (0)

Report

Im in australia and hate working with dates too.

Dont know if it will help but i think your convert time zone is wrong. it should be "(UTC) Coordinated Universal Time"

The best thing for you to do is to chuck in some compose actions with the two sides of your condition and compare them to see why they do not match. SharePoint Date/Time column's always have a time in them even if not set i.e. 00:00 so you may have more luck with contains rather than equals.

Was this reply helpful? Yes No
spinneroo 242 on at

Like (0)

Report

Hi thanks for your response.
I changed it to the correct univesal time.
I'm not sure what you mean by compose actions. Can you explain further?

Was this reply helpful? Yes No
gristcooper 25 on at

Like (0)

Report

Search for Compose in the actions.
Add a couple of them,

In one put the data from SharePoint in the Other put your output from the converted date and time.

Once the flow runs, look at the run history and you will see exactly what each side of the condition looks like.

Was this reply helpful? Yes No
spinneroo 242 on at

Like (0)

Report

I found the issue.

Firstly I did a couple of other things. I followed this tutorial on creating a TodayDate column.

Then I said if Future Approval Date = TodayDate then etc etc

While looking at the compose actions, I noticed the Flow started working after midday today. Even though I have convert time zone, for some reason it is running behind. Not sure how to fix that but my condition works, which is the main thing.

Do you have any further ideas on how to fix the time issue?

Thanks for your help so far 🙂

Was this reply helpful? Yes No
Gristy 2,429 on at

Like (0)

Report

Please show the examples of what you mean 🙂

Was this reply helpful? Yes No
spinneroo 242 on at

Like (0)

Report

Not sure how to show examples
The TodayDate was one day behind up until midday. As soon as midday clicked over, it changed.

Was this reply helpful? Yes No
Gristy 2,429 on at

Like (0)

Report

Hi,

Sorry i meant after the flow has run, you can inspect it and see what values actually are.

It looks like you are not using the converted time at all though, you are using a SharePoint Column rather than the output of the conversion action

Was this reply helpful? Yes No
spinneroo 242 on at

Like (0)

Report

Ok, thank you 🙂
Can you tell me how I use the converted time? I didn't see anything on that when I was looking at tutorials.
Should I put TodayDate in the base time field?

Was this reply helpful? Yes No
Gristy 2,429 on at

Like (0)

Report

Hey, if you click in the condition, you should see in the dynamic data the output from the action instead of the sharepoint icon it will have the same icon.

Was this reply helpful? Yes No
spinneroo 242 on at

Like (0)

Report

I'm sorry but you have completely lost me.

Was this reply helpful? Yes No