cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Saul85
Helper I
Helper I

Email with Options Reminder

Good morning,


I have a flow which sends and email with options to a Group, and then, with the selected option updates a list in SP. The email with option has a time out of 28 days and what I want to add now is a reminder, 4 days before the flow expires, to all these people who didn't select any option.
I had tried this: https://powerusers.microsoft.com/t5/General-Power-Automate/Reminder-for-quot-email-with-options-quot... , but sent the reminder to all the group, even if they have already chosen an option.


This is a screenshot of my flow:

Captura de pantalla 2021-01-17 a las 10.31.52 a. m..png


Any suggestion?

 

Thanks a lot.  

2 REPLIES 2
tom_riha
Super User
Super User

Hello @Saul85 ,

I believe there's no direct way how to recognize inside the flow who already selected an option and who didn't. But if you're storing that information in a separate list, you could add a separate flow to send the reminders.

There would be 2 prerequisites (you could store the data in another SP list, let's call it Configuration list):

  • List of users who should respond
  • Date when the email with options was sent

Then it would be a scheduled flow that would run every day:

  • check if today is 24 days from the day when the email with options was sent. If no, do nothing. If yes, continue:
  • compare the 2 lists - for each user in the Configuration list check if they already selected an option (they'll have an entry in the current SP list). If yes, do nothing. If no, store them in an array/string variable of 'users to remind':
  • send an email to the 'users to remind'


[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]

Hi @tom_riha 

 

Thanks a lot for your help.

 

I will have to adapt what you suggested to fulfil my requirements.

 

I was wondering that I could filter who selected the option and who didn't inside the flow.

 

Regards.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,135)