Power Platform Community Forum Thread Details

Hi everyone,

Hoping for some admin help please 😊

We have a Power Automate flow connected to Salesforce that mostly works, but we’re struggling with duplicate Teams notifications.

What the flow should do

When an Opportunity is updated to Closed Won, the flow posts a message in Microsoft Teams saying “Well done”.

Because the Salesforce timestamps can be slightly out (sometimes by ~1 second), we’re comparing two datetime fields:

LastModifiedDate

ia_crm__Synced_With_Intacct_Date_1__c (Intacct sync datetime)

To allow a small tolerance either side, we converted both datetimes to ticks and used the following logic:

Expression (ticks difference in seconds):

div(
  sub(
    ticks(triggerBody()?['LastModifiedDate']),
    ticks(triggerBody()?['ia_crm__Synced_With_Intacct_Date_1__c'])
  ),
  10000000
)

Conditions (AND):

is greater than or equal to -10

is less than or equal to 10

So effectively, we’re allowing a ±10 second window.

The issue

This works for the initial Closed Won update, but if someone edits the Opportunity later (even unrelated fields), the flow posts the “well done” message again.

We assumed the above time-window conditions would prevent repeat posts, but it still fires if the record is modified again.

What we need help with

What’s the best way to ensure the Teams message is posted only once per Opportunity?

Any suggestions on what to change/add (e.g., extra conditions, storing state, checking if the “Closed Won” change happened this time vs earlier) would be greatly appreciated.

Thanks in advance!

Categories:

Building flows

Using flows