Skip to main content

Notifications

Power Automate - Building Flows
Answered

Sending emails for the following month

(0) ShareShare
ReportReport
Posted on by 2
Hi everyone, 
 
I'm a bit stumped. I have an excel spreadsheet with expiring projects. I'd like to send out a list of the expiring projects to the corresponding manager the month before they expire. E.g. On May 15th, I'd like to automate an email listing all the projects that expire in June. 
 
Any suggestions?
  • Verified answer
    ankit_singhal Profile Picture
    ankit_singhal 379 on at
    Sending emails for the following month
    You can create a schedule flow which can trigger daily or according to your needs (like the 15th date of month). You can read data from excel file and compare the date with today's date. if your condition is met for send the email then compose an email and send. 

    Note: Please Mark verified, if it is useful for you 

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,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard