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.
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
Was this reply helpful?YesNo
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.
2
Share
Report
All responses (
Answers (
