Creating a Flow to Send an Email Reminder Based Off a Date in a SharePoint List

(0) Share

Report

Posted on by CU25071648-0

I am trying to set up a flow based off a date formatted column in a SharePoint list. I want the flow to review the date field, and if the current date is 45 days after that date field, send an email.

Flow set up:

1. Recurrence (Set to run every morning)

2. Get Items (To Search and filter SharePoint list items to query items from a specific category, requiring reminders after 45 days of column date)

3. For Each

4. Condition:

If Dynamic Date Field is equal to formatDateTime(utcNow(),-45, 'dd-MM-yyyy')

5. If True, send email.

6. If False, do nothing.

Flow works until it hits the condition, and always returns a false result, even though I have one entry that would prove true. When reviewing the test under condition, there is a warning that state: The expression contains dynamic functions, variables or parameters that cannot be resolved in the debugger.

I'm sure I am formatting the condition statement incorrectly, I just do not know how to fix this.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

David_MA 14,956 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
You don't show your flow, so I am not 100 percent sure what you're doing. However, if you want to get items for a specific date (45 days after a date in this case), I've found you need to use greater than or equal to and less than in the filter query or condition. Filtering on dates includes the time stamp of the item, so using equal to is almost never going to work.

ge expression: addDays(startOfDay(utcNow()), -45)

lt expression: addDays(startOfDay(utcNow()), -44)

Using the startOfDay() expression is key as it sets the time portion to 00:00:00 and is why this works.

This way, you get everything that was created from 00:00 to 23:59 on January 3, 2026 (45 days prior to today).

If you are not using a filter query as I show above, but are using a condition to check the date after the get items action, note that by default the get items action only returns the first 100 items in the list. This is why it is better to use a filter query so you get what you need from the start. If your list goes above 5,000 items, be sure to index the date field being used in the filter query. If you don't once the list exceeds 5,000 items the filter will only look at the first 5,000 items in the list.

Was this reply helpful? Yes No
CU25071648-0 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much for taking the time to respond. I genuinely appreciate your insights.

I have a filter query set to only pick items that are in the Category requiring a 45 day notice, which seems to be working and when testing, it returns 24 entries.

I added greater than and less than conditions as you suggested in the Condition, however, I'm still seeing the False warning.

Attached

Was this reply helpful? Yes No
CU25071648-0 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Greg Prickril 165 on at

Like
a
(1)

Report
Copy link

Link copied!

Conditions are often a pain. Create a compose prior and do the comparison to see what's happening. Not being able to see the resolved values is a real bummer and time sink in Power Automate.

Was this reply helpful? Yes No
David_MA 14,956 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

I would use a filter query instead of a condition. Why do you want to use a condition? How many items are in your list? If there are more than 100, you might not be getting any results because without the filter query the flow will only get the first 100 items. None of those items probably meet the condition. This is why it is better to use a filter query for what you are asking to do.

If you insist on using a condition, they tend to work better by using an expression on left that returns a Boolean. In your case, you want both conditions to evaluate to true.

Was this reply helpful? Yes No