web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : OO1paV6LyXrPZcpTogvbsP
Power Automate - Using Flows
Unanswered

Send weekly reminder mails without using Recurrence template in MS flows

Like (0) ShareShare
ReportReport
Posted on 27 Feb 2020 08:43:07 by 2

I have to send weekly reminder mails without using Recurrence template in MS flows

 

Example: I have DueDate field in SharePoint List once Dudate Crosses then weekly once reminder mail should goto action owner .

Any solution is appreciated!!!

 

 

I have the same question (0)
  • efialttes Profile Picture
    14,756 on 27 Feb 2020 at 12:36:13
    Re: Send weekly reminder mails without using Recurrence template in MS flows

    Hi

    Does your organization allow you 'When an HTTP request is received' trigger and 'HTTP' action block?

    THere is an old technique to implement long running flows (longer than the default expiration of a flow, I mean) by nesting several flows via HTTP.

    https://www.techmikael.com/2018/01/how-to-architect-long-running-flows.html

    So I was thinking on a Flow triggered by means of an HTTP GET action, with a Do Until lasting for 28 days, this loop would include a Delay until, so it would take care of the reporting th first two weeks. Once completed, it should trigger a second flow instance and terminate. Please note I haven't tested if a flow instance can trigger another instance of the same flow.

    Hope this helps

     

  • RobElliott Profile Picture
    10,234 Super User 2025 Season 2 on 27 Feb 2020 at 12:04:44
    Re: Send weekly reminder mails without using Recurrence template in MS flows

    @mani the only solution I can think of is that you add a button to each item of your SharePoint list and you manually start the flow for any items that have passed the due date.
    So in your list you would have a single line of text column which you format using JSON code:

    {
     "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
     "elmType": "button",
     "txtContent": "Complete form",
     "customRowAction": {
     "action": "executeFlow",
     "actionParams": "{\"id\": \"52b76de4-f775-456c-87ad-61c46714990a\"}"
     }
    }

    You would change the txtContent line to the button text that you want. You also change ID of your flow from my Id to yours (from the browser address bar):

    0-formatColumn.png

     

    1-forSelectedItem-ID.png

    Your flow has a SharePoint trigger "For a selected item".

    I will look at the syntax to only show the button if today's date is later than the due date. But for the moment that will get you going and is the only solution I can see if a recurrence trigger can't be used.

    Rob
    Los Gallardos
    If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

  • mani Profile Picture
    2 on 27 Feb 2020 at 11:39:52
    Re: Send weekly reminder mails without using Recurrence template in MS flows

    Hi ,

     

    I can't use recurrence trigger in my organisation they have blocked automatic triggers . So i need any alternate solution for that

     

    Thanks in advance!!!

  • efialttes Profile Picture
    14,756 on 27 Feb 2020 at 11:26:05
    Re: Send weekly reminder mails without using Recurrence template in MS flows

    Hi

    You mean you cannot use Recurrence template or you cannot use REcurrence trigger?

    With such trigger you can implement whatever flow logic, no need to reuse the template

    Hope this helps

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Tom Macfarlan – Community Spotlight

We are honored to recognize Tom Macfarlan as our Community Spotlight for October…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 626 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 374 Moderator

#3
Expiscornovus Profile Picture

Expiscornovus 284 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Restore a deleted flow