Power Automate

Configure a loop until today's date is greater than the due date in a SharePoint list

(0) Share

Report

Posted on by EdMoh

Hi,

I would like to setup a reminder system using PowerAutomate, and send me reminders in due dates.

the problem is that some "Due Dates" are far away, e.g. 1 year from now...

in PowerAutomate, I cannot use the "Delay until" for more than 30 days, that is my plan setup in O365..

so, I would like to create a loop in Power Automate and keep pausing for 1 week every time if "today's Date" is less than the "due date" mentioned in a SharePoint (Date\Time) field..

I used the (Do Until) with the following expression but it's not working..

greater(ticks(formatDateTime(utcNow(), 'yyyy-MM-ddTHH:mm:ssZ')), ticks(triggerOutputs()?['body/The_x0020_Reminder_x0020_Date_x0']))
 
please find attached screenshot.
 
can you please advice what might be the issue here? any idea?
 
thank you!

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

EdMoh 68 on at

Like (0)

Report
Copy link

Link copied!

screenshot attached

Was this reply helpful? Yes No
Suggested answer

Kalathiya 2,353 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello @EdMoh,

Based on your requirement, if the goal is to send a notification on the due date, you actually don’t need to use Delay or Do Until at all.

Instead of keeping the flow “waiting” until the due date, you can use a Scheduled (Recurrence) flow that runs daily (or at any interval you prefer) and simply compare Today’s date with the Due Date field in SharePoint.

How this works

Create a Scheduled flow that runs once per day (for example, every morning).

Use Get items from SharePoint and apply a filter to retrieve only the relevant records:

Filter items where Due Date = Today

Optionally include ReminderSent = No (use this only if you are tracking whether a reminder was already sent).

3. Use Apply to each to process only the filtered items returned by SharePoint.

4. Send the email notification for each matching item.

5. (Optional) Update the item to set ReminderSent = Yes so the same reminder is not sent again.

If this solution works for you, please let me know and feel free to ask if you need more help.

📩 Need more help? Mention@Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping

Was this reply helpful? Yes No
EdMoh 68 on at

Like (0)

Report
Copy link

Link copied!

Hi @Kalathiya

thank you for your suggestion.

I will give it a try.

I have a question: I would like to write an expression that check if today's date is "greater" than the due date, can you please advise if you have a working expression?

I tried: greater(ticks(formatDateTime(utcNow(), 'yyyy-MM-ddTHH:mm:ssZ')), ticks(triggerOutputs()?['body/The_x0020_Reminder_x0020_Date_x0']))

but that didn't work.

Was this reply helpful? Yes No
Kalathiya 2,353 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello @EdMoh,

In Power Automate, you don’t actually need to use ticks() to compare dates. Date/time values can be compared directly as long as both sides are valid DateTime values.

greater( formatDateTime(utcNow(), 'yyyy/MM/dd'), formatDateTime(triggerOutputs()?['body/The_x0020_Reminder_x0020_Date_x0'], 'yyyy/MM/dd') )

If today’s date is greater than the due/reminder date, the expression will return true else false.

Output

Was this reply helpful? Yes No
Suggested answer

Riyaz_riz11 4,191 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Your expression compares today > due date, but in a reminder loop you want to keep looping while today < due date, then exit once it’s reached.

Use this in the Do until condition: lessOrEquals(ticks(utcNow()), ticks(triggerOutputs()?['body/The_x0020_Reminder_x0020_Date_x0'])) and keep the right‑hand value as true.

Inside the loop, just have a Delay – 1 week; the loop will re‑check the condition after each delay.

Also increase the Do until – Change limits (timeout and max iterations) so it can run long enough to cover up to a year.

If I have answered your question, please mark it as the preferred solution ✅ . If you like my response, please give it a Thumbs Up 👍.
Regards,
Riyaz

Was this reply helpful? Yes No