Learn how to get a list of columns including their display- and internal name
There are several Chrome extensions that makes life a little easier when working with SharePoint.
SharePoint Dev Tools is a tool, that I use to compare the Display Name with the Internal Name, and we can even get the type of the column.
If you are working with JSON formatting, or on a list with many columns, this is a good way to get a good overview of all the columns available.
If you are looking for a single internal name of a single column, the fastest way is to sort by or filter by that column, and grab the internal from the URL, but I still had many use cases where this extensions was helpful.
Here is an example where I have sorted by column, so that I can grab the internal name from the URL
How to use the extension
When you have downloaded the extension, go to your SharePoint site, click on the extension icon and select Lists & Document Libraries
In the search panel, make sure that only to URL to your site it written, otherwise you won’t get any hits (here is room for improvements for the tool), so your URL should be
https://tenant.sharepoint.com/sites/yourpagename
Now we will have a selection, of all of the available libraries and lists on your site.
Select the relevant list, and now we can compare all of the internal names, their display names, and even the type
A wonderful tool that I have found myself using in many occasions 👍
See also
- Change status for a list item with JSON (choice column)
- Make a download button for SharePoint Library files
- Update metadata for locked/checked out/need approval files
- Disable the folder ID for SharePoint document integration
- Trigger a Power Automate Flow with modern ribbon, with a custom button in Dynamics 365 (not Ribbon Workbench)