Skip to main content

Notifications

Power Automate - Building Flows
Answered

Sending emails for the following month

Posted on 27 Nov 2024 01:29:03 by
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 322 on 27 Nov 2024 at 05:14:03
    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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,129

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,797

Leaderboard