Skip to main content

Notifications

Community site session details

Community site session details

Session Id : rhksJ7pHOUyiykvul0tfiT
Power Automate - Building Flows
Unanswered

Microsoft TEAMS lists - use Power Automate to notify the channel of new/updated issues

Like (0) ShareShare
ReportReport
Posted on 22 Sep 2023 14:16:53 by

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

  • creativeopinion Profile Picture
    10,406 Super User 2025 Season 1 on 22 Sep 2023 at 14:52:49
    Re: Microsoft TEAMS lists - use Power Automate to notify the channel of new/updated issues

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

    creativeopinion_1-1695394079156.png

     

    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.

    creativeopinion_3-1695394222656.png

    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. 

     

    creativeopinion_2-1695394135124.png

     

    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

     

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 57

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 47 Super User 2025 Season 1

#3
rzaneti Profile Picture

rzaneti 29 Super User 2025 Season 1

Overall leaderboard