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

Community site session details

Session Id : Rn5xa3xhdDlR/SR+f2eWmH
Power Automate - Building Flows
Answered

If yes, how to send Teams messages only once?

Like (0) ShareShare
ReportReport
Posted on 13 Sep 2023 08:47:16 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 21 Sep 2023 at 08:28:02
    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 21 Sep 2023 at 07:59:01
    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 21 Sep 2023 at 03:43:43
    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 14 Sep 2023 at 02:26:51
    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 13 Sep 2023 at 10:16:01
    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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete