cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Daved1
Helper II
Helper II

Trying to delete column that is linked to a Choice

I have a column in a Table linked to a Choice.  I want to delete it and use a Lookup instead.

 

I cannot delete due to dependency to Choice.  I went to Solution, and checked the dependency and the only one is the link to the Choice.

 

How do I break this dependency so i can delete this column ?

Thanks

 

1 ACCEPTED SOLUTION

Accepted Solutions
dpoggemann
Super User
Super User

Hi @Daved1 ,

 

You should be able to delete the column with the Choice still existing, it would stop you from deleting the Choice if you had a column on a table that utilizes.

 

Please check dependencies on the column of the table, I assume it is still on a form or view etc. that is causing the issue.

See top of screen here showing the "Show Dependencies" option

Screen Shot 2021-09-26 at 10.03.29 AM.pngScreen Shot 2021-09-26 at 10.05.44 AM.png

 

If still stuck, please attach screen shot for the dependency but overall it should never go in that direction.

 

Hope this helps.  Please Accept if answers your question or Like if helps in any way.


Thanks,


Drew

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew

View solution in original post

5 REPLIES 5
dpoggemann
Super User
Super User

Hi @Daved1 ,

 

You should be able to delete the column with the Choice still existing, it would stop you from deleting the Choice if you had a column on a table that utilizes.

 

Please check dependencies on the column of the table, I assume it is still on a form or view etc. that is causing the issue.

See top of screen here showing the "Show Dependencies" option

Screen Shot 2021-09-26 at 10.03.29 AM.pngScreen Shot 2021-09-26 at 10.05.44 AM.png

 

If still stuck, please attach screen shot for the dependency but overall it should never go in that direction.

 

Hope this helps.  Please Accept if answers your question or Like if helps in any way.


Thanks,


Drew

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew
rampprakash
Super User
Super User

Hello @Daved1,

 

Yes @dpoggemann comment will 100% work for you.

 

 

Hi @dpoggemann 

 

I did delete the column from a View yesterday, yet still could not delete the column.  THis morning i tried to delete the column again, and it works - i was able to delete !  Looks like it took some hours before the deletion of the column from the view got registered .

 

Thanks

Dave

dpoggemann
Super User
Super User

Hi @Daved1 ,

 

After you delete the column from the View you need to "Publish All Customizations" or it won't recognize the delete. 😀. After this you can delete the column.

 

Glad you got it!


Thanks,


Drew

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew
Daved1
Helper II
Helper II

Hi @dpoggemann 

 

I was not aware of this.  Thanks for the extra info - appreciate it

 

Dave

 

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (1,590)