cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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 8

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 8

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
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 Kudoed Authors
Users Online
Currently online: 347 members 5,995 guests
Please welcome our newest community members: