Good morning,

I built an MS TEAMS Channel and added Lists to build an issue tracker for my organization/agency. What I would like to do is use Power Automate (or another MS app - I'm open to suggestions) to notify all members of the Channel via email when a new issue is added, or a current issue is edited/updated.

What I've done so far:

Created an "automated cloud flow" to alert members/owners via TEAMS notification. I believe this worked for the most part - a notification pop-up appeared in the lower right portion of my screen within a few minutes of added/editing an issue.

Created an "automated cloud flow" to alert members/owners via email (outlook, state agency). This was unsuccessful and the email received is attached. In the settings for emails, it appears to allow the creator to add columns and information from the 'list' (issue tracker) to the email, which would provide the email recipient (member/owner) with enough details where they would not have to open TEAMS to review the issue.

Here are the steps taken:

Opened the channel/list up in Sharepoint (from TEAMS)

Click on "integrate", "power automate", "create a flow"

Click on "send a customized email when a new SharePoint list item is added" (on the right side menu)

Click on "create flow" on the bottom of the screen

Items I would like to resolve:

No information from the issue/item transposes to the email. I would like some information from the list issue to be included in the email.

The email is coming from me and being sent to me and is not being sent to the other team channel members/owners. How do I modify this to have the email sent to the entire channel?

Thank you very much in advance!

David Cohen

Categories:

Building flows

@davidcohen You need a way to return the email addresses of your Team members.

Get Team Members

Add a Get a team action to your flow and select your team. Then add a List group members (Office 365 Groups) Action to your flow and insert the Team ID dynamic content from the Get a team action.

The List group members action will return an array of members.

Add a Select action and insert the value dynamic content from the List group members action into the From field. In the Map field, click on the icon to switch from map mode to text mode.

Insert the Mail dynamic content from the List group members action. This action will select only the email addresses returned from the List group members action.

The Select action will return an array. You will need to convert that into a string. Add a Join action and insert the outputs from the Select action into the From field. Then in the Join with field insert a semi-colon.

Run a test.

The join action will return a string of email addresses separated by a semi-colon. You can use the outputs from the Join action in your Send an email action.

Can you please upload a screenshot of your flow? It would help to troubleshoot the other issue you are having.

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉Watch my tutorials on YouTube
👉Tips and Tricks on TikTok