Unanswered

Read-only column after importing from Access

(0) Share

Report

Posted on by 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

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (11)

Answers (0)

Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@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?

Was this reply helpful? Yes No
ccg_apl 26 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
ccg_apl 26 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Fubar 8,338 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
ccg_apl 26 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
ccg_apl 26 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Nhelgren on at

Like (0)

Report

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

Was this reply helpful? Yes No
ccg_apl 26 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
CourtneyOwen Microsoft Employee on at

Like (0)

Report

For the fields that are exhibiting the read-only behavior in Dataverse, were they set as primary keys in the original Access tables? If so, we think we know what the issue is and are working on a fix.

Was this reply helpful? Yes No