Unable to Delete Model App from Environment

(0) Share

Report

Posted on by jrrausch

I have a Model App that I am not able to delete from the Environment we created it in. When trying to delete I get this error:

Sql error: Statement conflicted with a constraint. The DELETE statement conflicted with the REFERENCE constraint "appaction_appactionrule_classicrulesOne". The conflict occurred in database "db_crmcorenam_20230910_01180642_8f7d", table "dbo.appaction_appactionrule_classicrulesBase", column 'appactionid'. The statement has been terminated. CRM ErrorCode: -2147185375 Sql ErrorCode: -2146232060 Sql Number: 547

I've removed everything from the app - just have a single data page pointed at one of our tables, but I still cannot get it to delete. Any ideas/suggestions for how to resolve?

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Gabriel G. 831 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi there,

I'm not sure I understand your situation. Here is what you need to do to delete a model driven app from a solution/environment:

Go to Make.powerapps.com and reach 'Solutions':

Use Default Solution, which is the first one down:

Then on the '...' on the model-driven app you want to delete, you use Delete from environement:

It is the same way you did ? Otherwise, we gonna need more information about your situation.

I hope it helps!

_____________________________________________

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.

Was this reply helpful? Yes No
jrrausch 18 on at

Like (0)

Report
Copy link

Link copied!

Yes, those are the steps I am taking that is generating the error message in my original post.

Was this reply helpful? Yes No
venturemavenwill 1,193 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Try adding an empty page to the model driven app, and then publish the app again.

After that, try deleting it.

You may have an orphan reference in the model driven app. Even though you deleted the tables from the model driven app, the reference is still there, which prevents the model driven app from being deleted.

Was this reply helpful? Yes No
jrrausch 18 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the idea.

I have removed everything that was originally in the app and now just have a single page with the Dynamics Overview Dashboard, but still the same issue.

This is what the app looks like now:

Was this reply helpful? Yes No
venturemavenwill 1,193 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Try going to classic, and make sure that all dependencies are really gone (entities, BPF, etc)

Was this reply helpful? Yes No
BenLeung 10 on at

Like (0)

Report
Copy link

Link copied!
Hi @jrrausch,

I just met the same issue, here's my way to delete the application

get appmoduleid from url of the MDA editor.

leverage the SQL4DBS (XrmToolbox tool) to query the related appactionid and appactionruleid

use Dataverse REST BUILDER (XrmToolbox tool) to disassociate appactionid with appactionruleid you query at step 2

use Dataverse REST BUILDER delete the app action record by id

once delete all the app actions, try to re-delete the model driven app.

Was this reply helpful? Yes No
Suggested answer

Van Nguyen Anh 2 on at

Like (0)

Report
Copy link

Link copied!

In my case, I have to go to "Show dependencies" of Model-driven App. After that remove all dependencies which have Object type is "App action".

When all "App action" dependencies were removed, I able to delete my app.

Was this reply helpful? Yes No
SF-26021517-0 2 on at

Like (0)

Report
Copy link

Link copied!

I can't delete any model-friven apps that I created. It tells me they have dependencis, but won't tell me what those dependencies are, where I can find them, or hw to remove them.I'm also tols that i don't have permissions to remove the apps, even if I try to delte apps that I've only just created. This seems really poor.

Was this reply helpful? Yes No