Send email reminder 30 days after hired date

NBMS_2019 · ‎04-21-2022

I have a SharePoint list with a column "employee start or hired date".

I want to send an email reminder once 30 days have passed from the hired date then another after 60 days if status column is still showing in progress. Need help with this.

Do I need to run a recurrence power automate to check the list everyday? Thanks for your help.

VictorIvanidze · ‎04-22-2022

Yes - create a scheduled cloud flow and run it every working day.

________________________________________________________

I can get your flow faster. For money. Email me or visit my web site.

NBMS_2019 · ‎04-22-2022

The Start Date has this value 1999-05-17T00:00:00Z but I am getting this error message. I am just adding 1 day for testing purpose.

Unable to process template language expressions in action 'Delay_until' inputs at line '0' and column '0': 'The template language function 'addDays' expects its first parameter to be a string that contains the time. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#adddays for usage details.'.

VictorIvanidze · ‎04-23-2022

It means that there is no triggerBody()?[StartDate']

________________________________________________________

I can get your flow faster. For money. Email me or visit my web site.

NBMS_2019 · ‎04-24-2022

Thank you for your help. I added a calculated data 30day column to add 30 days from the start date column then run a recurrence power automate to run everyday to check 30days date = UTCNOW then send a reminder. Had to do a number of formatdate expression to match dates 00/00/2022 = 00/00/2022 format.

ScottShearer · ‎04-24-2022

@NBMS_2019

Please remember that a Flow can run for a maximum of 30 days.

You probably should re-write your Flow to use a Recurrence trigger (as suggested by @VictorIvanidze) that fires every day.

Then, you'll retrieve rows from your data source that meet your criteria, loop through them and send an email to each.

Where is your data stored? SharePoint? What type of column is your Status column? A choice column?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

NBMS_2019 · ‎04-26-2022

Thank you for your input - already doing it - "run a recurrence power automate to run everyday"

ScottShearer · ‎04-26-2022

@NBMS_2019

Are you saying that you have solved your issue? If not, please post a screen shot of your current Flow. If you are using the recurrence trigger, you don't want to have the delay action that is shown in the screen shot that you posted.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott