How to send email to each user with an expired Document

user7878 61 Reputation points

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

    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


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


    3.Create the following Microsoft Flow:

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


    4.Save and Test this flow


    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