Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Send project update request email

(0) ShareShare
ReportReport
Posted on by 28

I have been working on a project for the last few months. I am at a point where I would like to put some notifications in place to the users of my app.

 

My goal: I want a flow to check dates in a field daily and send an email to the project owner (UserEmail) when the date meets criteria indicating it is time to make a project update. This is customized by allowing the project owner to select if they want email notifications by using GetNotifications (yes/no) and add a number of days in which they want to get an email prior to the follow-up date in the config list. The email subject line and body will show the project name and follow-up date. They will only get the email if GetNotifications is set to true. ***an extra bonus is to send one email with all the projects that meet these criteria for the user rather than individual emails***

Here is the setup I have:

 

I have 2 SharePoint 365 Lists

  1. UserConfig
  2. UserProjectData

The UserConfig list has all the user config in it. This list has 3 columns as follows:

  1. UserEmail – Single line of text
  2. GetNotifications – Yes/No
  3. DaysPriorExpiration – Number

The UserProjectData list has all the user config in it. This list has 3 columns as follows:

  1. UserEmail – Single line of text
  2. ProjectName - Single line of text
  3. FollowUpDate – Date and Time

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard