Forum Discussion
Send email two months in advance for people who signed up for something on Sharepoint list
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 con...
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
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.
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
- The "Person or Group" type
revolutionenergy Check below links to capture email addresses from person or group column:
- How to get email and send Email To Multiple Values In People Picker Field In SharePoint
- How to extract email address from a SharePoint person or group column that allows multiple selection
- SharePoint MS Flow - Send Email to People or Group field with Allow multiple selections and Allow selection of People and Groups
- 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