There is not possible right now to remove item that is not used in entity from Picklist that is used as column in such entity. There is error message being displayed that only new items can be added.
So if I'd like to update Picklist, I have to remove column in entity and then add and fill every row again. This is not user friendly. There is also possible to use Picklist for example in dropdown and if I'm not able to edit it when bounded to entity users will see items that are not used in entity.
So please my suggestion is to make possible to also remove items from picklist that are not used in entity that is using this picklist as a column.
The scenario in this case will be:
1) Error in case that item in picklist is selected/used in entity with name/list of entities
2) If not used in entity, make it possible to delete item in picklist
Hi @vecerpa - thanks for reaching out - the ability to delete picklists (option set) items from a list that has already been added to an entity that contains data is already available in the latest version of the Common Data Service for Apps.
The error message you're seeing will occur on previous versions.
To access the latest version, you have two options - first is to wait for the update process for existing environments that should be rolling out later this month, or to create a new environment to get access to the latest features.