Unanswered

How to compare dates in a SharePoint List?

(0) Share

Report

Posted on by LTomas

Good day!

I am having a hard time comparing dates in power automate. My logic supposed to be is that when the value in "Start of Use" column is less than or equal to the current dateTime, it will have to update that certain item.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

MarkoKrstanovic 97 on at

Like (0)

Report

Hello,

TICKS is one of the way to do that.

In this case i created flow that triggers manually with date input.

Its important that dates are in the same format, as you can see utcNow() is formated in MM-dd-yyyy format,
if needed do the same for sharepoint date.

My input date was today's date, and as you can see Compose returned same numbers and condition is true

Hope this would help 🙂

BR Marko

Was this reply helpful? Yes No
LTomas 40 on at

Like (0)

Report

Is there a way to loop this per item in a SharePoint list? I am having issues initializing it under the condition flow.

Was this reply helpful? Yes No
LTomas 40 on at

Like (0)

Report

Was this reply helpful? Yes No
MarkoKrstanovic 97 on at

Like (0)

Report

Try like this:

Was this reply helpful? Yes No