question

jokeefe-1842 avatar image
0 Votes"
jokeefe-1842 asked PramodValavala-MSFT answered

Is there a way to reset the rowversion stored in logic app connector

Hi,

I have written a logic app that uses the When an item is modified V2 connector. This is working as expected however the Db on my test environment is restored from a back up each night. This causes the row versions in the database to become out of sync with the row version currently stored by the logic app Sql connector each day. This then means that I am unable to execute the trigger without performing a large number of random updates to get the two back in sync.

Is there a way to reset or change the rowversion that the logic app stores so I do not have to do this?

azure-logic-apps
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

PramodValavala-MSFT avatar image
0 Votes"
PramodValavala-MSFT answered

@jokeefe-1842 Unfortunately, there isn't a way today to reset the trigger state, but the steps mentioned in this blog are a good workaround. The steps to follow would be

  1. Disable the Logic App

  2. Change Trigger settings to something else and Save

  3. Change Trigger settings back as required and Save

  4. Enable the Logic App




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.