Send email two months in advance for people who signed up for something on Sharepoint list

[revolutionenergy]

Hey there,

I've created a Sharepoint list for conferences in my company's field where individuals can go into the list and "sign themselves up" for a conference in a particular column of that conference's row in the list.  I'd like to automatically send them an email in advance of the conference to remind them they signed up - is this possible?  The date of the conference is also in the conference's row of the list. I believe Power Automate probably has some way to do this but can't figure it out quite yet.

TLDR: Trying to send an email to people who signed up for a conference ahead of the conference's start date - the data for those who signed up and the start date of the conference are in the same row in a list.

[#2]

@revolutionenergy Follow below tutorial, it should help you: Event Reminder Flow 

---

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

[#3]

@ganeshsanap Hi,

Unfortunately this does not solve my issue of needing to send an email to people who specifically signed up for the conference in the list. Is there a way to do that?

[#4]

@revolutionenergy Above article is just for reference to get started with. It will not have exact similar requirements like your use case.

You can use similar scheduled flow which will trigger at specified time. You can compare date column values to see it date is approaching and collect email addresses of users from same list item/row to send email notification.

If you are using multiple selection person column for storing user name who signed up for event/training, it will be easier to collect their email addresses to send email notification.

---

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

[#5]

Yes, I understand this, but am not sure how to collect the user email address. Their profiles are stored in the same row (different item) and I want to send the email to everyone who has put their profile in the same row.

[#6]

@revolutionenergy Which column type you have used for storing user names?

---

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

[#7]

The "Person or Group" type

[#8]

@revolutionenergy Check below links to capture email addresses from person or group column:

1. How to get email and send Email To Multiple Values In People Picker Field In SharePoint 
2. How to extract email address from a SharePoint person or group column that allows multiple selection 
3. SharePoint MS Flow - Send Email to People or Group field with Allow multiple selections and Allow se... 
4. Power Automate Flow multiple selection column 

Hope it helps!

---

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs