How do I make the ID column un-editable (again) in a Microsoft List?

[WThompson]

This is an issue that deals with Microsoft Lists and data types and fields.  It could arise while working with Power BI because Power BI is all about data representation.  The fact that I am working with Power APPs instead of Power BI does not prevent me from reaching out here in hopes that someone here might have a solution to my problem.  I admit I am casting a wide net in hopes of finding a bright mind to shine a light on this.

Microsoft List is the evolved version of SharePoint List. I am working with Microsoft List before ever touching SharePoint List. So I do not know what features are carried over from the SharePoint version.

There is an default ID column which comes with a List. As I understand, it auto-increments as the user adds a new row to the List.

I decided to make this column visible to show in the List. I did this so that this ID can be used as the primary key value that can be used when a user wants to modify or look up an item in the List.

But I found that when the user clicks to add a new item, the ID field appears for the user to add an ID. This is not good. Not only was I able to add an id that is way out of sequence, but I was able to create a record with an id that had already been assigned.

In an attempt to fix the problem, I set the ID to HIDDEN mode. But then, fir some reason, when I clicked to add a new item, the ID appeared for the user to enter an ID for that field.

I got a response to this issue from spiceworks and I will paraphrase the response and what I was suggested to do.

In Microsoft Lists, the ID column is a system field that automatically increments for each new item added. It is intended to be read-only and not directly editable by users. However, if the ID field is showing as editable when adding a new item, then it might be due to custom form customization or a glitch in the list settings.

To ensure the ID column remains un-editable, I followed these general steps:

1. Go to the List Settings by clicking on the gear icon in the top-right corner of the list page.
2. Under the Columns section, click on the ID column to view its settings.
3. If there's an option to make it read-only, ensure that is selected. (Typically, one cannot change the settings of the ID column as it's system-managed.)
4. If you've previously modified the form using Power Apps or any other custom form editor, revert those changes or edit the form again to make the ID field read-only.

If unable to change the ID field to read-only using List Settings, consider using Power Apps to customize the form:

1. Navigate to the list and select "Integrate" from the top menu.
2. Choose "Power Apps" followed by "Customize forms". In Power Apps, select the ID text input control.
3. Set its "DisplayMode" property to DisplayMode.View to make it read-only.
4. Save and publish your form changes.

Please note that direct modification of system fields like ID is not recommended and generally not possible through the standard list interface. If the ID field remains editable after these steps, it might be a temporary issue with Microsoft Lists, and you may need to contact Microsoft Support for further assistance.

I followed all 8 of the steps listed above, as best as possible and now I know what is wrong now but I do not know how to fix it.

So, starting at the beginning, the List/Grid view of the List shows a column titled "ID"

I clicked to show the settings but here is part of the problem. There is nothing in on the settings panel to denote the column, ID. It is simply not there at all.

Now, the problem finally comes to light when I click on the List Integrate -> Power Apps -> Customize forms

Do you see it? It calls the ID column, "Title". There is some sort of confusion between the ID field and the Title field. Since ID does not appear on the setting page, it has been somehow removed (it is a system level column name that, I am guessing, is not to be deleted -- I would think it should be impossible to delete, but it is still gone). So the ID I am using is a false ID, it is just a renamed Title column. Somehow Power APP knows this and calls it "Title". So this is a mess that I would like advice on how to untangle.

I am thinking to rename my ID to "Title" and then find some magic way to bring the ID back. This part is out of my proverbial wheel house. And I am looking for advice.

[PijushRoy · Accepted solution]

Hi @WThompson 

If I understand the requirement correctly
Click on The Field (the entry box)
Then GO to DisplayMode. You will find present display mode is DisplayMode.Edit
Change it to DisplayMode.View

If your requirement is solved, please make sure to MARK AS SOLUTION and help other users find the solution quickly. Please hit the LIKE button if this comment helps you.

Thanks
Pijush
www.MyAccountingTricks.com 
https://www.youtube.com/MyAccountingTricks