Read-only column after importing from Access

[ccg_apl]

I have an Access back end database that has been imported to DataVerse with the migration tool. After import, in Dataverse, some of the columns are read only. I (the owner) cannot edit them through any form or directly when viewing the table data in Dataverse.

I don't see anything different about these columns than others.. When I look at the column definitions via the API link, they are identical except for the expected IDs and field names - all settings match. 

Any ideas on how to get this field editable or why it isn't?

{"@odata.context":"https://redacted.crm.dynamics.com/api/data/v9.2/$metadata#EntityDefinitions('cr812_tblincoming')/Attributes/Microsoft.Dynamics.CRM.DecimalAttributeMetadata/$entity","@odata.type":"#Microsoft.Dynamics.CRM.DecimalAttributeMetadata","MaxValue":100000000000,"MinValue":-100000000000,"Precision":2,"ImeMode":"Disabled","FormulaDefinition":"","SourceTypeMask":0,"AttributeOf":null,"AttributeType":"Decimal","ColumnNumber":51,"DeprecatedVersion":null,"IntroducedVersion":"1.0.0.0","EntityLogicalName":"cr812_tblincoming","IsCustomAttribute":true,"IsPrimaryId":false,"IsValidODataAttribute":true,"IsPrimaryName":false,"IsValidForCreate":true,"IsValidForRead":true,"IsValidForUpdate":true,"CanBeSecuredForRead":true,"CanBeSecuredForCreate":true,"CanBeSecuredForUpdate":true,"IsSecured":false,"IsRetrievable":false,"IsFilterable":false,"IsSearchable":false,"IsManaged":false,"LinkedAttributeId":null,"LogicalName":"cr812_cases","IsValidForForm":true,"IsRequiredForForm":false,"IsValidForGrid":true,"SchemaName":"cr812_cases","ExternalName":null,"IsLogical":false,"IsDataSourceSecret":false,"InheritsFrom":null,"CreatedOn":"2022-07-20T19:46:54Z","ModifiedOn":"2022-07-20T19:46:54Z","SourceType":0,"AutoNumberFormat":null,"MetadataId":"f8bce0b2-6408-ed11-82e4-000d3a4fa96e","HasChanged":null,"AttributeTypeName":{"Value":"DecimalType"},"Description":{"LocalizedLabels":[],"UserLocalizedLabel":null},"DisplayName":{"LocalizedLabels":[{"Label":"Cases","LanguageCode":1033,"IsManaged":false,"MetadataId":"6a048b4d-4bf7-4252-a9d8-ede0fb2d81df","HasChanged":null}],"UserLocalizedLabel":{"Label":"Cases","LanguageCode":1033,"IsManaged":false,"MetadataId":"6a048b4d-4bf7-4252-a9d8-ede0fb2d81df","HasChanged":null}},"IsAuditEnabled":{"Value":true,"CanBeChanged":true,"ManagedPropertyLogicalName":"canmodifyauditsettings"},"IsGlobalFilterEnabled":{"Value":false,"CanBeChanged":true,"ManagedPropertyLogicalName":"canmodifyglobalfiltersettings"},"IsSortableEnabled":{"Value":false,"CanBeChanged":true,"ManagedPropertyLogicalName":"canmodifyissortablesettings"},"IsCustomizable":{"Value":true,"CanBeChanged":true,"ManagedPropertyLogicalName":"iscustomizable"},"IsRenameable":{"Value":true,"CanBeChanged":true,"ManagedPropertyLogicalName":"isrenameable"},"IsValidForAdvancedFind":{"Value":false,"CanBeChanged":true,"ManagedPropertyLogicalName":"canmodifysearchsettings"},"RequiredLevel":{"Value":"None","CanBeChanged":true,"ManagedPropertyLogicalName":"canmodifyrequirementlevelsettings"},"CanModifyAdditionalSettings":{"Value":true,"CanBeChanged":true,"ManagedPropertyLogicalName":"canmodifyadditionalsettings"},"Settings":[]}

--- to help with future searches:

readonly

read-only

read only

[rampprakash]

Hi @ccg_apl 

The one you have attached is of JSON format, we can Deserialize the same to get the Values Easily.

May i know where you are trying to achieve this by Javascript or c# code?

[Mira_Ghaly]

@ccg_apl

Is the read-only issue related to all columns imported?

What role is assigned to you on dataverse is it system admin or you have a specific role?

[ccg_apl]

I go to make.powerapps.com, go to my environment -> Dataverse -> tables -> table in question. it shows the first X rows and allows editing of those rows. all fields are editable except a select few, one of which i posted above.

I am the owner of the environment. The table's record ownership is set to User or Team. I have not set up any row or column specific permissions on any of the columns.

Note that MOST columns in this table are read-write as I would expect. Only 2 or 3 columns exhibit this problem.

[ccg_apl]

Most columns in this table are read-write as expected. Only 2 or 3 columns exhibit this problem.

I have these roles:

System Administrator

Basic User

Environment Maker

I go to make.powerapps.com, go to my environment -> Dataverse -> tables -> table in question. it shows the first X rows and allows editing of those rows. all fields are editable except a select few, one of which i posted above. 

The table's record ownership is set to User or Team. I have not set up any row or column specific permissions on any of the columns.

Another user, who also has Maker and Basic User roles, has the same problem with the same columns.

[Fubar]

How was the Column created? and have you Published after the Column was created?

Have you done any other changes such as set the field to being a Calculated field or Roll up field?

Have you added the field to a Form or have you only tried updating it in the List that shows on the Table definition? if only in the List create a Form for the Table add the field and then add it to a Model Driven App.

[ccg_apl]

The column was created through the Access Migration tool provided by Microsoft. No changes have been made to it since the import.

It has been added to a form in a canvas app, and it has the same problem there.

[ccg_apl]

As an update, I created a new environment and re-imported, and I no longer have the problem on these tables, but it now appears on other tables.

[NHelgren]

This is unexpected. Could you share the data types you are seeing on this? Have you opened a support case yet?

[ccg_apl]

I could not identify a pattern for when this happened. I posted one of the field definitions above, but as I mentioned, it didn't happen on the next import attempt.

At this point, the tables I'm actively using are behaving properly, so I haven't revisited this. If it surfaces again, I'll create a support request.