Answered

Cant Delete Column in dataverse due to Copilot view.

Like (0) Share

Report

Posted on 23 Aug 2023 12:50:31 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

Untitled.png

I have the same question (0)

Summarized by AI

All responses (8)

Answers (2)

Verified answer

ReubenS12 11 on 23 Aug 2023 at 13:01:54

Like (0)

Report

Re: Cant Delete Column in dataverse due to Copilot view.

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... on 23 Aug 2023 at 18:28:22

Like (0)

Report

Re: Cant Delete Column in dataverse due to Copilot view.

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 23 Aug 2023 at 22:31:16

Like (0)

Report

Re: Cant Delete Column in dataverse due to Copilot view.

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 29 Aug 2023 at 11:15:34

Like (0)

Report

Re: Cant Delete Column in dataverse due to Copilot view.

Try deleting the view itself.

Was this reply helpful? Yes No
Community Power Pla... on 29 Aug 2023 at 21:02:17

Like (0)

Report

Re: Cant Delete Column in dataverse due to Copilot view.

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 08 Sep 2023 at 02:12:11

Like (0)

Report

Re: Cant Delete Column in dataverse due to Copilot view.

@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 24 Sep 2023 at 16:48:47

Like (0)

Report

Re: Cant Delete Column in dataverse due to Copilot view.

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.

CoPilotView.png

Was this reply helpful? Yes No
Verified answer

PowerBi-Rick 80 on 24 Sep 2023 at 21:42:15

Like (0)

Report
Re: Cant Delete Column in dataverse due to Copilot view.

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