Automate Emails?

Question

First off, I would like to thank anyone who takes the time to think about this problem and help me with sourcing a solution! THANK YOU!

I am looking for the best way to automate emailing. Here's the problem: Currently, I have a list of people in an Excel spreadsheet (willing to convert to something else that helps with this problem) that has dates in it with a variety of things that expire - certifications, driver's licenses, auto insurances, etc... and very few, if any dates, match. Is there any way that I can automate emails to go out 60 days before the expiration of any of these things to the person whose paperwork is expiring, then if you haven't gotten it updated with new paperwork - send another email 30 days out and then once a week and daily for the last 7 days until the paperwork is provided? Is there also a way to have it email me 7 days out, so that person is on my radar? The template I found on Power Automate seem to need a specific trigger date and it would need to be kicked off manually. I am looking for something that would automatically run (including weekends) without anyone having to do anything.

Thank you again!!!

Answer 1

Use the Windows task scheduler to run a program/script on a daily basis. Use whatever programming language you are most familiar with to write the code. Find/borrow/hire a programmer if you can't write code. Define the task on a server that is normally up and running.

Process each record one by one and do an analysis of current date versus the date in the data record. Send emails when appropriate. You may need to use a database instead of Excel.

Answer 2

Unfortunately, Power Apps isn't supported on this forum. I recommend you post this on the Power Apps community forums at https://powerusers.microsoft.com/t5/Power-Apps-Community/ct-p/PowerApps1 and someone will gladly assist.

This does sound like a perfect task for Power Automate so please paste your question on their community.

————————

If this is helpful please accept answer.