Recurrence Triggers

[khaycock]

I'm looking to build a flow that sends weekly emails to a new starter at our company, with a maximum of 10 emails being sent over 9 weeks. 

Is this possible to do? I wasn't sure the best way to trigger this automatically apart from having a form that connects which someone can fill in the name and email of the person that the emails need to send to, but then I wasn't sure how to set up the weekly occurrences after that?

Any help is greatly appreciated! 

[Hardesh15 · Accepted solution]

@khaycock  If you are planing to inputs via MS FORM then store response in SharePoint List when someone respond. Once you have data in your list then create one recurrence flow which will send weekly emails.

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh

[khaycock]

Do you think there is a better way of doing it? 

[Hardesh15]

@khaycock  it will depend how you will collect data. 

But you have to store data first then create recurring flow on that data. 

What kind of improvement you want to see?

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh

[khaycock]

No idea really, you just made it sound like there was another option! Ultimately, instead of the Form, an admin could just write the name and email to a sharepoint list and that triggers the flow instead then?

[Hardesh15]

@khaycock  this is also fine. You can use this one as well. 

Let me know if you need anything.

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh

[Hardesh15]

@khaycock  let me give you options

1. MS Form

2. SharePoint list form

3. Powerapps form

4. Excel sheets

There are more but mostly used i listed. You can any mention option for your case.

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh

[khaycock]

Okay great, thank you! 

[khaycock]

Sorry I've just thought about this a bit more. I still need the names that are being entered to send off a trigger though, its not just all the names need all the emails. It's one person gets added and then that sends off 10 weeks of emails etc, rather than the whole list getting constant emails. Is that possible?

[Hardesh15]

@khaycock  Either one person can add all emails or you can take inputs from each user. Both will work here. When you willl create flow use Send email.

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh

[khaycock]

But surely I need to start the flow with recurrence to get the emails to be sent weekly? How else can I get them to be sent weekly?

[Hardesh15]

@khaycock There is another option for such thing. You can create one calculated column in SharePoint in which you can add 7 days to created date which will give you exact week date from today date. Then you can use this column in your flow.

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh

[khaycock]

How would I use these dates to trigger an email?

[brendenweaver]

Hi @khaycock , 

I encountered this same issue but just discovered a solution. Rather than creating it as a "Recurrence," (which I have not been able to find a way to trigger), instead create it as a "Trigger." Then, you can add a delay effect in between each action repeated multiple times, imitating the recurrence effect. 

For example, I need to send an email every week for 5 weeks once a new client is added (trigger). So, I create it as a trigger then manually add 5 email actions, each separated by a one week delay.

Hopefully this helps