How to send email to each user with an expired Document

Question

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.

Answer 1

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

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.