Answered

How to compare a datafield with utcnow-function?

(0) Share

Report

Posted on by JürgenD

166

Hello everyone,
i have a powerautomate workflow that is running daily. I get the elements from a sharepointlist a want to send an email if the Todo-Date is reached. The Todo-Column in the sharepointlist is of type "date".

I built a condition like this: "Todo <= utcnow()". But this condition does not work. The following action "Sending an Email" runs even if the Todo-date is in future. The other conditions work right.

Has anyone an idea, why that condition is not working properly?

Here is the expression for the two fields:

I hope that I have explained my problem in a comprehensible way and look forward to your answers.

Jürgen

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @JürgenD

I have a sharepoint list with column DueDate having column type as Date

Now in the condition I have specified condition like this

sub(ticks(items('Apply_to_each')?['DueDate']),ticks(formatDateTime(utcNow(),'yyyy-MM-dd')))

This function will calculate the ticks of dates [One tick is 100 nanoseconds, starting with 1st of January 0001 00:00:00] , and subtract them, if they are zero, it means due date and today's date are equal while if result is negative, it means today's date > due date , if it is positive, then due date > today's date.

For more details on using tick function
refer the below article
https://tomriha.com/how-to-calculate-difference-between-two-times-in-power-automate/#:~:text=To%20calculate%20a%20difference%20between,the%20days%2Fhours%2Fminutes.

Mark it as solution if it helps 🙂

Was this reply helpful? Yes No
JürgenD 166 on at

Like (1)

Report
Copy link

Link copied!

Hello and thanks for your help.
It works as described.
Kind regards
Jürgen

Was this reply helpful? Yes No
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @JürgenD

Glad to know it worked 🙂

Was this reply helpful? Yes No