cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

AX 2012 R2 | SQL -> When an item is created

Hallo,

 

I try to get a flow working to trigger when a new Project is created in AX 2012 R2

 

ATM I use a on-premise Gateway and just the Trigger 

When an items is created and Send an email

2019-01-07 13_52_56-Microsoft Edge.png

 

When I test the flow the following is showing

2019-01-07 13_56_07-Microsoft Edge.png

 

I also found the following

Recently, SQL Server trigger is only supported for SQL Server in Azure. SQL Server trigger is not supported for On-premises SQL Server.

 

at https://powerusers.microsoft.com/t5/Connecting-To-Data/SQL-Trigger-Not-working/td-p/61874

 

Is my flow oncorrect or is it cause I use an on-premis gateway?

 

KR GeDei

 

3 REPLIES 3
Community Support
Community Support

Hi @Anonymous,

 

Yes, SQL Server trigger is only supported for SQL Server in Azure.

If you are using on-premises SQL Server, it won’t work.

Please check the following blog on triggers in the SQL connector:

https://flow.microsoft.com/en-us/blog/introducing-triggers-in-the-sql-connector/

More details about connector SQL Server, please check it at here:

https://docs.microsoft.com/en-us/connectors/sql/

 

Best regards,

Mabel

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hi, actually I'm using an on-premise Gateway + When an item is created and it is working. The problem was that there was no IDENTITY column in the table. So it seems for me it is working with on-premise and SQL trigger.

Hi,

 

Can you help providing some explanation ?

How did you identified if table has an IDENTITY  column and where do you place that information on trigger.

 

Please share your solution

 

Thanks

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (12,688)