Hi,all.
One Excel file in Sharepoint has multiple sheets, and each sheet has a table.
Could you please let me know if there is a way to send a message in Teams only when a specific table is updated?
Currently, updating any table sends a message to Teams.
The flow is below.
1)When an item or file is modified
name of list or library:document
2)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>
3)List rows that exist in a table
document library:document
table:table-A
4)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>
5)add to string variable 3
Name:List
value:</table>
6)conditions 2
Sharepoint updater email address is equal:My email address
if yes,Post a message in a chat or channel
Thank you in advance.