How to send email to each user with an expired Document

user7878 61 Reputation points
2021-09-12T15:01:13.337+00:00

I'm pretty new to Sharepoint, so please be patient with me. My question is it possible to be able to send email to each user which has expired documents and be able to know when the expiry date email was sent. The item contains worker name, their expiry date, and the heading of 'Expiry Date Send Date' which is empty right now and few other headings.

I looked around the internet and all I could find was to be able to send email to one address rather then to each of the user with the expiry document.

SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
2,767 questions
0 comments No comments
{count} votes

Accepted answer
  1. Echo Du_MSFT 17,126 Reputation points
    2021-09-13T06:57:07.913+00:00

    Hello @user7878 ,

    Welcome to Q&A Forum!

    Please following steps:

    • SharePoint Online:

    1.Create the below columns in the library:

    • WorkerName: Person or Group
    • ExpiryDate: Date and time
    • ExpiryDateSendDate: Date and time

    131521-spo1.png

    2.Automate >> Power Automate >> Create a flow

    131489-spo2.png

    3.Create the following Microsoft Flow:

    • ExpiryDateSendDate is equal to formatDateTime(utcNow(),'yyyy-MM-dd')

    131446-spoflow.png

    4.Save and Test this flow

    131512-spo4.png

    Thanks,
    Echo Du

    ============================

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    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 comments No comments

0 additional answers

Sort by: Most helpful