Reply
Level: Powered On
Posts: 12
Registered: ‎12-07-2016

Re: dml triggers causing failure of table updates

Hi @v-micsh-msft any update on this please? More people seem to be experiencing this issue and keen for a workaround. Please let us know if it is being worked on - I have had to delay my rollout of PowerApps to my org because of this so would llike to understand the time frame for it being investigated and (hopefully) resolved.

 

Thanks

Graham

Community Support Team
Posts: 2,813
Registered: ‎09-20-2016

Re: dml triggers causing failure of table updates

Hi @gcoates and others,

 

Apologize that currently I don't have any information regarding the date, I will try to forward this again.

Appreciate your patience.

Regards

Microsoft Employee
Posts: 1
Registered: ‎02-28-2017

Re: dml triggers causing failure of table updates

Hi,

 

I am also facing the same issue. My powerapp was working perfectly fine until I added triggers(AFTER INSERT & AFTER DELETE) to the database which has been connected to the powerapp.

 

Request anyone to update the thread if they have a workaround. I shall also let you guys know about a workaround if I find soemthing.

 

Thanks,

Karthik

Level: Powered On
Posts: 31
Registered: ‎04-04-2017

Re: dml triggers causing failure of table updates

Same problem here.

 

We have an app writing back to an on-prem SQL server table with an update trigger.

 

Show stopper for us!

 

Any news @v-micsh-msft???

Level: Power Up
Posts: 1
Registered: ‎04-05-2017

Re: dml triggers causing failure of table updates

We're having the same problem, triggers have been fundamental in data architecture for decades. I hope Microsoft fix this else PowerApps can go on the junk heap.

 

 

 

 

 

Highlighted
Level: Powered On
Posts: 31
Registered: ‎04-04-2017

Re: dml triggers causing failure of table updates

https://powerusers.microsoft.com/t5/PowerApps-Ideas/Enable-use-of-triggers-in-Azure-SQL-Tables/idc-p...

 

Appears to be treated like a Feature based on this. At least it's planned!