Unanswered

How do I change Dataverse table columns from read-only to editable?

(0) Share

Report

Posted on by JFitch55

I am creating my first PowerApp in Teams & using Dataverse as the data source. (This is not my first PowerApp; it's my first in Teams with Dataverse.) I created the Environment & the app with no issues of which I'm aware.

I created a table named WorkPeriods & added 4 columns (with indicated data types): ID (primary, autonumber); ConsultantName (single-line text); DateTimeIn (date & time); DateTimeOut (date & time). I saved the table, then opened it & selected "Edit data" to load a few records to begin app development. However, I am unable to enter data because all columns are "read only". I understand why ID would be read-only (good!), but not the others. I have searched MS Documentation & Bing-searched the issue, but am unable to find a solution.

How do I either (1) change the read-only columns so that they are editable &/or (2) create a Dataverse table so that its columns can be edited?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (0)

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @JFitch55 ,

Would you like to edit data in the table which you created in Dataverse for Teams?

If so, you could add columns in "Edit data" manu and values in those added column is editable:

Former added columns also could be deleted here in this page.

Hope this helps.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
JFitch55 12 on at

Like (0)

Report
Copy link

Link copied!
Thank you for your reply. I am trying to do two things: (1) create 2 columns that are Date and Time data type; and (2) enter data (records) in the table. I tried your suggestion (i.e., delete columns I had created; create new columns from the "Edit data" menu; and enter data via "Edit data" menu). It was partially successful.
Delete columns? Success
Add new columns? Partial success: I added new columns, but the "Date and Time" data type was not available in the dropdown menu, so I selected "Date" data type. I saved & closed the table, then came back to it via Teams > Power Apps > Build > Tables > [TableName] to attempt to change the data type, but that is not possible. I followed the "Learn more" link from the Edit Column pane to Type of columns which indicates that "Date and Time" should be available.
Edit data? Failure. I tried to add new rows, but could not save them. Error message: "Columns have invalid values." I had created the Primary Name Column with Autonumber data type. (This table has only numeric & date-time data types; no text columns.) When I added new rows, Dataverse did not populate the Primary Name Column with the next autonumber & there was no way for me to add it manually. So, without a value entered in this required primary key column, I could not save the record.

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @JFitch55 ,

So I found that after modifying the Primary Name Column to a Autonumber type column, in Edit data it is remains a Text type column, and even make it read-only:
I think with this situation, you may left the Primary Name Column Text type. Since you only would like to create records for test, I would recommend you to create the table with columns you need then create test data within an Edit Form and Submit Button in the App.

Hope this helps.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
ManojAhuja 43 on at

Like (4)

Report
Copy link

Link copied!
Hello,
Recently when I started working on the dataverse for teams I came across the similar issue.
The below solution worked for me. You may refer if still facing this issue.
Edit the column which is read only.
Go to advance options.
Change the behavior tab to Date Only.
It worked for me.
Thanks.

Was this reply helpful? Yes No