
Announcements
Hi,
I am trying to build a flow that will send a reminder of a date from a hire date in a sharepoint list.
one that will send a email to the manager 2 weeks before the 6 month performance review based on the hire date.
and one on their year anniversary. I have a list that has calculated column to find the dates but kind of at a lost on where to start with power automate.
Any help would be appreciated.
You will need to make a Scheduled flow that runs daily or weekly. Then it Gets Items from the SharePoint list and loops through them checking the date column. If the date column - 12 days is equal to today, then send an email.
You'll have to a condition with expressions something like addDays([Your SP Column], -12, 'MM/dd/yyyy') is equal to utcNow('MM/dd/yyyy') then send an email.