ID Calculated Column Not Showing

Question

I have created a calculated column to show the ID in an opened List item. This is using =ID in the formula box.

However, in the actual List item, the vasty majority are showing ID as 0:

There does not seem to be a pattern for this,

Does anyone have an explanation for this?

davemehr365 · Answer

Hi CIManager_0102​&nbsp;
The ID is calculated only after saving and is available for sharing only then.&nbsp;
I think a good solution might be to create a flow that runs after the element is created and retrieves the ID.
&nbsp;
Best, Dave

virendrak · Answer

If your requirement is simply to display the&nbsp;Item ID on the list's Edit form, you can use JSON form formatting instead of creating a separate lookup column.Add the JSON under Configure layout &gt; Header. This is a simpler approach and avoids adding unnecessary columns to the list{
    "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
    "elmType": "div",
    "style": {
        "margin": "10px",
        "padding": "8px 12px",
        "border-radius": "4px",
        "border": "=if([$ID] == '', '1px solid #ffb900', '1px solid #c7e0f4')",
        "background-color": "=if([$ID] == '', '#fff4ce', '#f3f9fd')"
    },
    "children": [
        {
            "elmType": "div",
            "style": {
                "font-weight": "400",
                "color": "=if([$ID] == '', '#8a6d00', '#005a9e')"
            },
            "txtContent": "=if([$ID] == '', '⚠ Item ID will be generated after the item is created and will be visible in Edit mode.', 'Item ID: ' + [$ID])"
        }
    ]
}&nbsp;

cimanager_0102 · Answer

Thank you, that seems to work for the main window. However, I'm looking for a solution to show the ID when the list item is opened. This solution does not appear to have affected that.&nbsp;

virendrak · Answer

The solution I provided will work once the list item has been created and opened in Edit mode / view mode.

When you click on +New

When you click on existing item:

You can include ID column in list view as well, when click on details of item the ID will be visible.

Forum Discussion

ID Calculated Column Not Showing

4 Replies