Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
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. 

  • Patricia11 Profile Picture
    on at
    Re: If yes, how to send Teams messages only once?

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

     

  • Verified answer
    pengwei Profile Picture
    139 on at
    Re: If yes, how to send Teams messages only once?

    @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
    Re: If yes, how to send Teams messages only once?

    Hi, @v-yetonggu-msft 

     

    Have you had time to look into this?

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

  • Patricia11 Profile Picture
    on at
    Re: If yes, how to send Teams messages only once?

    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.

  • v-yetonggu-msft Profile Picture
    on at
    Re: If yes, how to send Teams messages only once?

    Hi @Patricia11 ,

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

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492