cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate II
Advocate II

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

Highlighted
Community Support
Community Support

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

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Microsoft
Microsoft

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

Highlighted
Anonymous
Not applicable

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???

Highlighted
New Member

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
Anonymous
Not applicable

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!

Highlighted
Advocate II
Advocate II

Re: dml triggers causing failure of table updates

It's already more than 3 years old and it's still the same problem. @v-micsh-msft @v-kamyne 

 

Is there a solution date?

 

Regards Jesus.

Highlighted
Regular Visitor

Re: dml triggers causing failure of table updates

Hellloooooo???

 

@v-micsh-msft @v-kamyne 

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (9,157)