Forum Discussion
Strydom1977
Sep 20, 2023Copper Contributor
Sending individual emails based on a multiple selection person/group column
Hi, I'm trying to isolate the individual email addresses based on a multiple selection person/group column and then send the individual an email rather than all email addresses in the column. ...
LeonPavesic
Sep 20, 2023Silver Contributor
Hi Strydom1977,
Sending individual emails based on a multiple selection person/group column in Power Automate is a possibility
Here is an example of how you could use this to send individual emails to members of a team when a new project is created:
- Create a new flow in Power Automate and select the "When an item is created" trigger for a SharePoint list that contains your team members.
- Add an "Apply to each" action to your flow and select the "Team members" column as the input.
- Add a "Get user profile" action to the "Apply to each" loop and select the "Email" field as the output.
- Add a "Send an email" action to the "Apply to each" loop and enter the recipient's email address in the "To" field.
- In the subject line, you could enter something like "New project created!" and in the body of the email, you could include a link to the new project.
- Save your flow and test it to make sure that it is working as expected.
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.
Kindest regards,
Leon Pavesic