cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lota
Level: Powered On

How to set up a recurring email including new Forms submissions

Hello,

I am setting up a Flow but it doesn't seem to work.

The idea is to have one email approval sent on each Friday 10am to ten people, with every new submission which has been entered into a specific Form in the past week.

What I realized is that by using Recurrence, the new submission is no longer a trigger of email. As a result, no email is sent at all. Could anyone please give me a hint on how to handle this?

Recurring flow.png

1 ACCEPTED SOLUTION

Accepted Solutions
SamPo
Level 10

Re: How to set up a recurring email including new Forms submissions

@lota 

There are 2 ways to do this:

 

1) Use 2 separate flows and a sharepoint list - Have one flow that is triggered when a new form is submitted and save the answers in a list. Then use another flow which runs each week at 10am and retrieve the answers from the list which you can then send in the email

 

2) Use a delay until option. When the response is submitted you can calculate the date of the closest friday using the current time function and day of the week function. Then use the 'delay until' option to delay your flow to be run at 10am on the calculated date.

 

Hope this helps

 

Sam

View solution in original post

2 REPLIES 2
SamPo
Level 10

Re: How to set up a recurring email including new Forms submissions

@lota 

There are 2 ways to do this:

 

1) Use 2 separate flows and a sharepoint list - Have one flow that is triggered when a new form is submitted and save the answers in a list. Then use another flow which runs each week at 10am and retrieve the answers from the list which you can then send in the email

 

2) Use a delay until option. When the response is submitted you can calculate the date of the closest friday using the current time function and day of the week function. Then use the 'delay until' option to delay your flow to be run at 10am on the calculated date.

 

Hope this helps

 

Sam

View solution in original post

lota
Level: Powered On

Re: How to set up a recurring email including new Forms submissions

Thank you! I didn't think about two Flows. I will try out.

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Speakers, submit your sessions now! Call for speakers ends Feb. 10!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,002)