web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / If yes, how to send Te...
Power Automate
Answered

If yes, how to send Teams messages only once?

(0) ShareShare
ReportReport
Posted on by

Hi,all.

If yes, how can I send a Teams message only once?

Currently, Teams messages are sent twice.

 

1.png

Thank you in advance. 

Categories:
I have the same question (0)
  • v-yetonggu-msft Profile Picture
    Microsoft Employee on at

    Hi @Patricia11 ,

    Could you show me the details of the flow, such as the content of the first Apply to each?

  • Patricia11 Profile Picture
    on at

    Hi, @v-yetonggu-msft 

    Thank you for your reply.
    The flow is below.


    1)Trigger the flow manually

     

    2)Get file (properties only) ※sharepoint

     

    3)Initialize variables
    Name:List
    kinds:string
    value:
    <table border=”1″>
    <tr bgcolor =”#999999″>
    <th valign = “middle” align=”center”>Seat type</th>
    <th valign = “middle” align=”center”>No.</th>
    <th valign = “middle” align=”center”>manager</th>
    <th valign = “middle” align=”center”>Project name</th>
    <th valign = “middle” align=”center”>Contract line name</th>
    </tr>

     

    4)List rows that exist in a table

     

    5)Apply to each
     conditions:Sheet type is equal to, etc.
    if yes,add to string variable
    Name:List
    value:
    <tr>
    <td>Seat type</td>
    <td>No.</td>
    <td>manager</td>
    <td>Project name</td>
    <td>Contract line name</td>
    </tr>

     

    6)add to string variable 3
    Name:List
    value:</table>

     

    7)Apply to each 3
    conditions 2
    Sharepoint updater email address is equal:My email address
    if yes,Post a message in a chat or channel

     

    powerautomate01.png

     

    powerautomate02.png

     

    powerautomate03.png

    powerautomate04.png

     


    Thank you in advance.

  • Patricia11 Profile Picture
    on at

    Hi, @v-yetonggu-msft 

     

    Have you had time to look into this?

    Please let me know if you need more information concerning this matter.

  • Verified answer
    pengwei Profile Picture
    139 on at

    @Patricia11 

     

    If there are two Teams messages posted, would it be caused by there are 2 files both matching your condition?


    To check on this part, you may view your running history.

     

    Alternatively in your If yes branch, you can add in a compose to display the File's ID or identifier. In this way, you may confirm how many files matched to your condition.

  • Patricia11 Profile Picture
    on at

    @pengwei 

    Thank you for your reply.

    There were two files matching the conditions in one folder, so I moved one file and the problem was resolved.
    Thank you for your help.

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 953

#2
Valantis Profile Picture

Valantis 810

#3
Haque Profile Picture

Haque 622

Last 30 days Overall leaderboard