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

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022- Season 2 has kicked off!

Users online (4,085)