cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KevRichards
Frequent Visitor

Power Automate Email with Options send and then output to Sharepoint

Have set up a flow to send an email with options.  Response is a formatted date variable to select one or the other.  

This works fine but... 

 

  1. How do stop it waiting for a response before sending next email (to a different recipient)?   
  2. What I then want to do is to output that response (along with other relevant information) into a Sharepoint file...thoughts?




1 ACCEPTED SOLUTION

Accepted Solutions
v-jefferni
Community Support
Community Support

Hi @KevRichards ,

 

Could you please share more details about your scenario?

 

For the first question, would you like to stop the flow action waiting for a response after sending the first Email for a while then send another email to other recipients? If you will stop the flow without getting a response, how will it continue to save the response to SharePoint? Or do you mean to save the response from the second email?

 

Anyway, you can set the Timeout for the first send Email action:

vjefferni_0-1653630368026.png

 

For the second question, which kind of file do you want to save the response? You will always be able to save the response to a variable for using later.

 

Best regards,

 

 

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

4 REPLIES 4
v-jefferni
Community Support
Community Support

Hi @KevRichards ,

 

Could you please share more details about your scenario?

 

For the first question, would you like to stop the flow action waiting for a response after sending the first Email for a while then send another email to other recipients? If you will stop the flow without getting a response, how will it continue to save the response to SharePoint? Or do you mean to save the response from the second email?

 

Anyway, you can set the Timeout for the first send Email action:

vjefferni_0-1653630368026.png

 

For the second question, which kind of file do you want to save the response? You will always be able to save the response to a variable for using later.

 

Best regards,

 

 

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

KevRichards
Frequent Visitor

@v-jefferni apologies for delay. 

I am trying to send an email with options per record to a recipient (email addresses, different one per record).  

 

Problem 1:   flow will wait for a response from previous email before sending the next (to a different recipient).  What I want is to send all the records emails regardless whether a response or not and not have to wait.

 

KevRichards_0-1654593261665.png

 

 

Problem 2: As per above, I want to capture the response(s), in a SharePoint file.  Format of response based on initialized variable earlier in flow (e.g. EO3Mth'): 

formatDateTime(addDays(startOfMonth(body('EO3Mth')),-1,'MM-dd-yyyy'),'dd/MM/yyyy')  

 

However, I get the below error message...


KevRichards_1-1654593546339.png

 

 


KevRichards
Frequent Visitor

Have tested the Timeout option but, as expected, just kills the flow and then unable to get the responses. Have also looked in 'Concurrency Control' but ends up sending to wrong recipient or again waiting for a response depending on which 'Apply To Each' section (see image above).   

Any help gratefully appreciated! 🤔😧

KevRichards
Frequent Visitor

Problem 1.  - 'Wait for a response'. 
Work around to output records to a Sharepoint list first and then a separate flow with a trigger to run when list has a new record. 

Problem 2 - 'Date format to Sharepoint from response option'.  Doesn't like dd/MM/yyyy so formatted to dd-MMM-yy and was fine.   

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,382)