SharePoint Reminder for Days in Advance = 0

Brian Curtis 91 Reputation points
2021-12-30T14:40:33.017+00:00

Hello. I'm trying to use the SharePoint (modern) Reminder feature to set a reminder for when items in my list have reached or passed their Next Review Date (a date column).

Automate > Set a Reminder > (Next Review date column)
161455-reminder-1.png

Reminder Name, Duration = 0 days
161471-reminder-2.png

However, this doesn't seem to work. The reminder immediately flags all items as expired and sends email notices accordingly. Any idea if "zero" throws things off, and how to fix it? Thanks.

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,629 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Elsie Lu_MSFT 9,761 Reputation points
    2022-01-06T09:18:38.383+00:00

    Hi @Brian Curtis ,

    Sorry for the late response. I can reproduce the scenario in my end, per my understanding you could try to use flow to complete this requirement.

    Here I found an article about it you could:
    Working with Dates and Times inside of your flows

    And I would suggest you go to the forum which is dedicated to Power Automate for more professional advice:
    Microsoft Power Automate Community

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.