How to Display the SharePoint List ID in a Teams Kanban Card
Question details
Display the system-generated SharePoint List ID on a Kanban board card within a private Microsoft Teams channel.
- Product
- Microsoft Teams
- Device & OS
- not provided
- Scenario
- Customizing the display fields on a SharePoint List configured as a Kanban board view in Teams.
- Observed behavior
- The default ID column is visible in the general list view but is missing from the item details and cannot be added using the 'Customize the card' menu.
Verify that you have 'Edit' or 'Full Control' permissions for the SharePoint list, as you may need to create a new column to resolve this issue.
Create a Custom Column for the List ID
Since the SharePoint Kanban card layout does not natively support the system-generated ID field, creating a separate calculated or text column containing the ID allows you to bypass this limitation and display it on the card.
The native ID field in SharePoint is a system column that is sometimes excluded from modern view customizations, including the Kanban (Board) card layout in Microsoft Teams. By copying the ID value into a custom column, you can force it to appear.
Navigate to the SharePoint list from your browser (rather than inside Teams) to access full list settings. Click the gear icon in the top right and select 'List settings'.
Scroll down and click 'Create column'. Name the column 'Card ID' (or similar) and choose 'Calculated (calculation based on other columns)' as the column type.
In the formula box, type =[ID] and set the data type returned from this formula to 'Single line of text'. Click 'OK' to save the new column.
Return to your Microsoft Teams channel, open the Kanban board view of your list, click the view dropdown in the upper right, and select 'Customize card'. Your new 'Card ID' column will now be available to toggle on.
Test Channel Settings and Version
Occasionally, specific Teams versions or private channel restrictions can interfere with list views. Testing in a standard channel can help isolate the issue.
Boost Your Productivity with WPS Office
While resolving Microsoft Teams and SharePoint list views requires adjusting Microsoft settings, you can optimize your everyday document workflows using WPS Office. It is a highly compatible, free alternative to Microsoft Office that easily handles Word, Excel, and PowerPoint files without expensive subscriptions.
- 1. Download the Installer: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Install WPS Office: Run the downloaded setup file and follow the on-screen instructions to complete the installation in just a few minutes.
- 3. Open Office Files: Launch WPS Office and instantly open any Microsoft Office format (.docx, .xlsx, .pptx) with full formatting compatibility.
Frequently Asked Questions
Why does the ID column show in the SharePoint list view but not on the Kanban card?
The Kanban (Board) view in SharePoint and Teams uses a specific rendering engine that restricts certain system-generated fields, like the default [ID] column, from being added to the visual card layout, even if they are toggled on in the standard grid view.
Can I display other custom columns on the SharePoint Kanban card?
Yes. Most user-created columns, such as Single line of text, Choice, Date and Time, and Person fields, can be freely added to the card layout by clicking the view selector in the top right and choosing 'Customize card'.
How do I access 'Customize the card' in Microsoft Teams?
Open your SharePoint list tab in Teams. Ensure you are currently using the 'Board' or 'Kanban' view. Click on the view name in the upper-right corner to open a dropdown menu, and select 'Customize card' to check or uncheck the fields you want to display.
