question

user7878-0682 avatar image
0 Votes"
user7878-0682 asked EchoDu-MSFT answered

How to send email to each user with an expired Document

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-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

EchoDu-MSFT avatar image
0 Votes"
EchoDu-MSFT answered

Hello @user7878-0682 ,

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.







spo1.png (24.9 KiB)
spo2.png (32.3 KiB)
spoflow.png (93.1 KiB)
spo4.png (58.8 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.