cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JKingy94
Regular Visitor

Sending email 3 months after MS Forms survey is submitted

Hi Everyone

 

I am trying to create a Flow that sends an email to an individual 3 months after they submit a response to a survey via MS Forms. I can get it working for a period of time less than 30 days, so am wondering whether there is a limit? I am very new to using Flows and so there is a strong possibility that I have overlooked something so any help would be much appreciated please.

 

If there is no way to do this, does anyone have any alternative suggestions?

 

Thanks

7 REPLIES 7
Jcook
MVP

Hello,
Yes flow will only run for a maximum of 30 days than it will time out.

My suggestion:
Store the email and the date registered in a SharePoint list.
Now have a secondary flow that runs daily to list items in the list and add 90 days to the date by using the expression:
adddays()
Than compare the today’s date with the date from SharePoint after the add days have been applied.
Use a if block to see if dates match and if they do send email.

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





ChristianAbata
Community Champion
Community Champion

hi @JKingy94  yes there is a limit just to 30 days.



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA
JKingy94
Regular Visitor

Hi @Jcook 

 

Thanks for your reply. I have created the list in SharePoint but am now stuck on how to set up the second flow to add 90 days, are you able to help please? 🙂

 

Thanks

Yes of course,

Could you share with me how the SharePoint list is setup.

If you could. Share a picture of the list with some test data.

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





JKingy94
Regular Visitor

Is this ok?

 

List Data.PNG

 

 

 

 

There are other questions on the survey but these are the ones we what to be able to pull through ready for the emails to be sent out.

Hello @JKingy94 

 

Here is a POC. I have created a List just like yours. I did not know the type of column you used for your Response Submitted. So i just used a Single Text type.

 

1) Use a recurrence trigger and trigger once a day. I suggest early in morning like 8am.

 

2) Add a Compose action. Here use the expression:

addDays(utcNow(), 90, 'dd/MM/yyyy')
 
3) Add a SharePoint Get items action, and specify a filter Query by using:
ResponseSubmitted eq '<Insert Dynamic Output>'
 
4) Add a Apply to each loop and input the value from get items
 
5) inside your loop add the send email action
pic1.png

 

pic2.png

 

pic3.png

 

 

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





@JKingy94 

Could you provide us with an update on your flow?

 

Thank you!


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (4,460)