SQL Server connector trigger don't work

[Anonymous]

Hi!

I'm looking for information about why trigger doesn't work for me. 

The table isn't showing up even at trigger. In the action I have objects to choose.

I think maybe my account doesn't have permission to trigger at SQL however what is needed to allow me to work with that trigger?

[JohnAageAnderse]

Hello @Anonymous 

Did you find a solution to your issue or is it still relevant?

The account that runs the flow or is used in the connection must have permission to access the tables that you need.

Tell us how far you got.

Kind regards, John

[Anonymous · Accepted solution]

Hey I know the solution.

Generally we miss two columns which are essential.

When invoking triggers, we have the following limitations:

• A ROWVERSION column is required for OnUpdatedItems
• An IDENTITY column is required for OnNewItems