Answered

Cant Delete Column in dataverse due to Copilot view.

(0) Share

Report

Posted on by ReubenS12

Essentially I have copilot turned off for the environment and I am doing some work on a table which I wanted to update and remove an outdated column. Essentially the below "Copilot view "is stopping me as its acting as a dependency and I cant delete this column , it appears to be only a recent change. There is no view in the dataverse table with this copilot so I am confused on what is causing this dependency on the column.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (8)

Answers (2)

Verified answer

ReubenS12 11 on at

Like (0)

Report
Copy link

Link copied!

I found the solution below.
https://www.youtube.com/watch?v=WGPOyoGI-ZI&ab_channel=RamprakashDuraisamy

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks for posting this. I followed the directions in the video but I still can't delete the column because it says there is a dependency even though the column isn't in the view.
This screenshot shows the dependency:

This screenshot shows that I have deleted all columns in the copilot view except the created on field:
I should be able to delete it but still can't.

Was this reply helpful? Yes No
David-CE 2 on at

Like (0)

Report
Copy link

Link copied!

I am having the same problem as Patriarch3257. I have followed the instructions in the video, the column isn't in the view but I still can't delete because Power Apps thinks there is a dependency.

Was this reply helpful? Yes No
ReubenS12 11 on at

Like (0)

Report
Copy link

Link copied!

Try deleting the view itself.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I looked for that but I don't see the copilot view in the views list. I think it's a system view.

Was this reply helpful? Yes No
Linn Zaw Win 2,996 on at

Like (0)

Report
Copy link

Link copied!

@TheArrayOfThing shared the workaround solution in this thread that they managed to remove the dependency using the "View Designer" in XrmToolBox.

The "Copilot View" is visible for selection there - and removing the column via "Edit XML" AND via "Edit Query" does remove the dependency.

https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Cannot-delete-column-with-dependencies-with-Copilot-View/m-p/2335967#M33233

Was this reply helpful? Yes No
PowerBi-Rick 80 on at

Like (0)

Report
Copy link

Link copied!

Has anyone else found any other solutions besides XrmToolbox. I have some old Lookup tables that I am trying to remove so that I can export my solution without dependencies and I and number of them have these 'can't delete due to CoPilot Views" errors. It's annoying to be stymied by something I didn't create and that just appeared from a Microsoft addition.

Was this reply helpful? Yes No
Verified answer

PowerBi-Rick 80 on at

Like (0)

Report
Copy link

Link copied!
Struggled to solve it but was finally able to do this in Classic mode

Open Fields for the Entity
Double Click on Dependencies in the header - one of the options will be the CoPilot View.
Double click the CoPilot View to open the View, then under the Actions dropdown, click Delete to delete the View. Save and Close.

Was this reply helpful? Yes No