How to notify a reviewer when the review date has passed on Teams/SharePoint

Katie Grant - BAS 20 Reputation points
2024-09-25T09:55:55.4266667+00:00

Hello,

I have a Document Library in MS Teams/SharePoint. I have a column called 'Reviewer', which pulls from Office 365. This is the 'Person/Group' option in SharePoint. I also have a Date column called 'Review Date'. This is the standard Date picker option in SharePoint.

Concept: User uploads a document, sets the reviewer and a review date.

What I want: When the review date hits on a document, an email is sent to the reviewer to let them know the document is due to a review. Currently the review date column is self pick, so users select the review date themselves.

I was going to use a Power Automate template for this, but I am not sure which option to select as none really seem relevant.

Any help would be appreciated :)

This is how it looks in Teams/SharePoint:

User's image

This is the Reviewer Column:

User's image

This is the Review Date column:

User's image

Thanks,

Katie.

Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
10,138 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,713 questions
SharePoint Workflow
SharePoint Workflow
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Workflow: An orchestrated and repeatable pattern of business activity, enabling data transformation, service provision, and information retrieval.
586 questions
0 comments No comments
{count} votes

Accepted answer
  1. LiweiTian-MSFT 19,475 Reputation points Microsoft Vendor
    2024-09-26T02:57:19.4633333+00:00

    Hi @Katie Grant - BAS

    You can create a flow that runs every day.

    This flow checks every day whether there is an item with Review Date equal to today. If there is an item equal to today, an email is sent to the Reviewer.

    I did a test for your reference:

    User's image

    User's image


    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.



0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.