Power Automate Email with Options send and then output to Sharepoint

[KevRichards]

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?

[v-jefferni · Accepted solution]

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:

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,

[KevRichards]

@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.

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]

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]

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.