SharePoint List Display Name and Internal Column Name Exporter PowerShell Script
In a SharePoint list, we usually use the user friendly (readable) names in list columns or fields. Each column has a display name and internal name which we also call as physical name of the column / field.
There are not many options for how to get the internal name and the easiest way is to copy it from the query string. This can be time consuming and error prone especially when working with many columns in a list.
The following PowerShell script will Export the SharePoint Column Display Name and Internal Name into a text file. This can then be used to create your document templates for SharePoint Document Merge or for any other Internal Column Name requirements (workflow, triggers etc…)
SharePoint Online: https://sharepointdocumentmerge.com/powershell/Get_list_columns_internal_names_SharePoint_Online.zip
SharePoint On-Prem: https://sharepointdocumentmerge.com/powershell/Get_list_columns_internal_names_SharePoint_On-Prem.zip