cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Creating a half yearly deadline reminder flow

Hi Guys,

 

I am trying to create a Power Automate flow which will send me deadline reminders every 6 months till the end date which is given in a SharePoint list.

 

The flow should give me a deadline reminder email 10, 5  and 1 days before the due date.

 

How can i achieve this. Kindly advice.

 

Regards

Srinath

3 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Resident Rockstar
Resident Rockstar

Re: Creating a half yearly deadline reminder flow

@Srinath 

I suggest on sharepoint you create a set of calculated fields corresponding to your reminders.

ReminderDate1

ReminderDate2

ReminderDate3

Then:

1. create a daily flow recurrence flow for each of these calculated dates that retrieves List items where:

ReminderDate1 eq utcNow('yyyy-MM-dd')

2. Loop on each item and send the reminder

 

 

 

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

View solution in original post

Highlighted
Impactful Individual
Impactful Individual

Re: Creating a half yearly deadline reminder flow

What Mira said. You can just use conditions for your reminders and use date diff etc. instead of calculated columns. But def. have something to compare to and have a scheduled trigger that scans for notifications and sends them when you get a match.

View solution in original post

Highlighted
Dual Super User III
Dual Super User III

Re: Creating a half yearly deadline reminder flow

@Srinath 

You can also use standard 'Set a reminder for sharepoint' flow and adapt it to your current needs. Steps to generate it explained in this excellent article, you will find also an explanation of its internal service logic:

https://www.sharepointsiren.com/2019/02/using-the-new-set-a-reminder-flow-for-sharepoint/

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

10 REPLIES 10
Highlighted
Resident Rockstar
Resident Rockstar

Re: Creating a half yearly deadline reminder flow

@Srinath 

I suggest on sharepoint you create a set of calculated fields corresponding to your reminders.

ReminderDate1

ReminderDate2

ReminderDate3

Then:

1. create a daily flow recurrence flow for each of these calculated dates that retrieves List items where:

ReminderDate1 eq utcNow('yyyy-MM-dd')

2. Loop on each item and send the reminder

 

 

 

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

View solution in original post

Highlighted
Impactful Individual
Impactful Individual

Re: Creating a half yearly deadline reminder flow

What Mira said. You can just use conditions for your reminders and use date diff etc. instead of calculated columns. But def. have something to compare to and have a scheduled trigger that scans for notifications and sends them when you get a match.

View solution in original post

Highlighted
Resident Rockstar
Resident Rockstar

Re: Creating a half yearly deadline reminder flow

Hey

 

@Srinath 

 

In addition to @Mira_Ghaly  and @cwebb365  inputs, you might want to have a look at   https://www.youtube.com/watch?v=O_zKexhMpkI 

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Highlighted
Dual Super User III
Dual Super User III

Re: Creating a half yearly deadline reminder flow

@Srinath 

You can also use standard 'Set a reminder for sharepoint' flow and adapt it to your current needs. Steps to generate it explained in this excellent article, you will find also an explanation of its internal service logic:

https://www.sharepointsiren.com/2019/02/using-the-new-set-a-reminder-flow-for-sharepoint/

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

Highlighted
Impactful Individual
Impactful Individual

Re: Creating a half yearly deadline reminder flow

Always forget about that workflow. That can be a good starting point and customize it form the template for sure.
Highlighted
Dual Super User III
Dual Super User III

Re: Creating a half yearly deadline reminder flow

@cwebb365 

Lots of options on the table. Let's wait for @Srinath 's progress on this challenge

Thanx for your kindness!

 



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Helper III
Helper III

Re: Creating a half yearly deadline reminder flow

Thanks for helping out @efialttes , @cwebb365 , @CFernandes , @Mira_Ghaly .

 

I was able to create a flow with all your inputs, which did the job.

 

I have one more doubt.

 

Is there a way i can add a day to a datetime value which comes from SharePoint List in the filter query in 'Get Items' action.

 

I am trying to send an email to update the deadline date if it was yesterday. I have a field EndDate in my SharePoint List.

 

Kindly advice on how to achieve this.

 

Thanks all for reaching out and helping.

 

Regards

Srinath

Highlighted
Dual Super User III
Dual Super User III

Re: Creating a half yearly deadline reminder flow

@Srinath 

So, your initial problem is now solved, right? If so

Congrats! Good Job!

Next steps? my humble suggestion is:

1.-Mark this topic as "Solved" by clicking "Accept as a solution". THis way others facing a similar problem can find a solution faster. Please also note you can even select several responses as solution, even from different community members!

Flow_AcceptSolution.png

2.- Open a new thread for your next question, following the policy: 'One Question, one post'. This way you have more chances to attrack attention for superusers that are seeking for unanswered topics.

 

Thanx for making this community great!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Helper III
Helper III

Re: Creating a half yearly deadline reminder flow

Hi @efialttes ,

 

I have accepted it as a solution.

 

Also glad to inform you that i have worked out a solution for my second question.

 

Thanks again for reaching out. Cheers!!

 

Regards

Srinath

Highlighted
Dual Super User III
Dual Super User III

Re: Creating a half yearly deadline reminder flow

Second challenge solved also?

Great Job!

Thanx for your kindness and Happy Flowing!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Helpful resources

Announcements
Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Top Solution Authors
Top Kudoed Authors
Users online (7,086)