Choices column in dataverse table write protected

[schwop]

Hi all,

I would like to add a multiselect column to my dataverse table. However, when I add the respective column using the type choices this column is write protected and I can't access the defined choice items. The same issue occurs when I try to implement a multiselect field via a lookup-table holding my items to choose from. I am using a Microsoft 365 E5 Developer Test account, but have the same issue with my work account running Microsoft 365 E3.

Many thanks in advance for any ideas

[dpoggemann]

Hi @schwop ,

Is this Dataverse for teams environment?  When you say right protected, help me understand what you are saying?  Are you exposing this through a model or canvas app?  Unable to patch?

Sorry for all the questions...

Thanks,

Drew

[schwop]

Hi @dpoggemann ,

yes, it is in the Dataverse for teams environment. Write protected means that the choices column is read-only when I try to enter values directly in the table (see screenshot below; "Schreibgeschützt" is german for read-only). I would like to connect the table to a canvas app but would like to enter some dummy data upfront 

[dpoggemann]

Hi @schwop ,

I have the same experience in my environment. Tried multiple approaches to edit (including trying to edit in Excel instead) and hitting same limitation.  I would suggest opening a case with support. 

Thanks much,

Drew

[Sunidhigambhir1]

The Choices function returns a table of the possible values for a  column.

Use the Choices function to provide a list of choices for your user to select from. This function is commonly used with the combo box, drop down controls. 

[NHelgren]

Hi @schwop, it appears you are trying to edit the Choices column in the Table Designer. It is showing Read Only there because the Table Designer doesn't have a control yet to modify that data type. If you go to the Design Hub instead and modify the column, you will find that you can make your changes. The team is working to bring data type parity ointo the Table Designer.

[dpoggemann]

Hi @NHelgren ,

I even used the "Edit In Excel" and this didn't work as well.   Can you explain the design hub to edit this as I am not sure I understand what this is vs. what I was doing to try to modify the data.

Thanks,

Drew

[NHelgren]

That is interesting about the limitation in Excel. Is the table part of a managed solution?

To get to the Design Hub:

1. On Build, pick See All in the "Items created for <<yourteam>>"

2. In the left hand menu Click Tables

3. Click the column

4. Click Edit Choice

If you have permissions to edit the table/field you should be able to add/rename items. If this is in a managed table and you are not the publisher you won't be able to edit it. If you cannot edit it and have sufficient permissions, please open a support case.

[dpoggemann]

Hi @NHelgren ,

this is an issue with adding or modifying the data itself, not the structure.  Unable to edit the rows for this Choices column in both the UI and Excel.  To me this is an issue and a case should be opened.

thanks,

Drew