SharePoint Online - system field mapping (internal name to display name)
lar404 opened this issue · 4 comments
I'm looking everywhere for official documentation that maps the display names to their internal names for SharePoint Online list and library system fields. The most comprehensive list I found is here: https://blog.softartisans.com/2009/12/08/list-of-internal-names-for-sharepoint-fields/ - however it's a third party blog, and quite dated.
Can this information please be made available to facilitate information architecture planning and data lifecycle management? Thank you.
Document Details
⚠ Do not edit this section. It is required for learn.microsoft.com ➟ GitHub issue linking.
- ID: c4820cfd-6c16-cf3d-dafe-faebe9db24ca
- Version Independent ID: 041df04f-8b58-d8a3-82a0-bfb330a7c3c9
- Content: SharePoint Naming Guidelines
- Content Source: Community/sharepoint-naming-guidelines.md
- Service: sharepoint-online
- GitHub Login: @pkbullock
- Microsoft Alias: daisyfeller
@lar404 - The easiest way to see this is to go to the Site Columns page in any site (Site Information / View all site settings / Site Columns). When you click on any Site Column, the URL on that page will have the InternalName in it. For example, for Birthday, you get the URL:
/_layouts/15/fldedit.aspx?field=Birthday
[parts of the URL removed for clarity]
I realize this isn't a reference, but the available Site Columns will vary depending on what features are enabled in any given site, even in "modern" SharePoint.
Does that help?
Alternatively, you could use PowerShell to export the DisplayName / InternalName plus any other information you might want. See: Get-PnPField
Hi @sympmarc - thanks for your reply. I'm currently using your first suggestion to get the information. I'm waiting on our GA to config environment to allow PnP use. If creation of a single reference point for this information is unlikely, happy for this issue to be closed. Thanks.
@lar404 - FWIW, here's a list of the StaticName/InternalName pairs for a site. As I mentioned, this list will vary depending on what type of site it is and what features/capabilities are enabled. I haven't filtered out hidden fields, etc. Hope this is useful.
StaticName | InternalName |
---|---|
_Author | _Author |
_Category | _Category |
_CheckinComment | _CheckinComment |
_CommentCount | _CommentCount |
_CommentFlags | _CommentFlags |
_Comments | _Comments |
_ComplianceFlags | _ComplianceFlags |
_ComplianceTag | _ComplianceTag |
_ComplianceTagUserId | _ComplianceTagUserId |
_ComplianceTagWrittenTime | _ComplianceTagWrittenTime |
_Contributor | _Contributor |
_CopySource | _CopySource |
_Coverage | _Coverage |
_DCDateCreated | _DCDateCreated |
_DCDateModified | _DCDateModified |
_EditMenuTableEnd | _EditMenuTableEnd |
_EditMenuTableStart | _EditMenuTableStart |
_EditMenuTableStart2 | _EditMenuTableStart2 |
_EndDate | _EndDate |
_Format | _Format |
_HasCopyDestinations | _HasCopyDestinations |
_Identifier | _Identifier |
_IsCurrentVersion | _IsCurrentVersion |
_IsRecord | _IsRecord |
_LastPrinted | _LastPrinted |
_Level | _Level |
_LikeCount | _LikeCount |
_ModerationComments | _ModerationComments |
_ModerationStatus | _ModerationStatus |
_Photo | _Photo |
_Publisher | _Publisher |
_Relation | _Relation |
_ResourceType | _ResourceType |
_Revision | _Revision |
_RightsManagement | _RightsManagement |
_SharedFileIndex | _SharedFileIndex |
_ShortcutSiteId | _ShortcutSiteId |
_ShortcutUniqueId | _ShortcutUniqueId |
_ShortcutUrl | _ShortcutUrl |
_ShortcutWebId | _ShortcutWebId |
_Source | _Source |
_SourceUrl | _SourceUrl |
_Status | _Status |
_ThemePreviewJson | _ThemePreviewJson |
_UIVersion | _UIVersion |
_UIVersionString | _UIVersionString |
_Version | _Version |
ActualWork | ActualWork |
AdminTaskAction | AdminTaskAction |
AdminTaskDescription | AdminTaskDescription |
AdminTaskOrder | AdminTaskOrder |
AllowEditing | AllowEditing |
AlternateThumbnailUrl | AlternateThumbnailUrl |
Anniversary | Anniversary |
AppAuthor | AppAuthor |
AppEditor | AppEditor |
AssignedTo | AssignedTo |
AssistantNumber | AssistantNumber |
AssistantsName | AssistantsName |
AssociatedListId | AssociatedListId |
Attachments | Attachments |
AttendeeStatus | AttendeeStatus |
Author | Author |
BaseAssociationGuid | BaseAssociationGuid |
BaseName | BaseName |
BestAnswerId | BestAnswerId |
BillingInformation | BillingInformation |
Birthday | Birthday |
Body | Body |
BodyAndMore | BodyAndMore |
BodyWasExpanded | BodyWasExpanded |
Break | Break |
Business2Number | Business2Number |
CallBack | CallBack |
CallbackNumber | CallbackNumber |
CallTime | CallTime |
CarNumber | CarNumber |
Categories | Categories |
Category | Category |
CellPhone | CellPhone |
Checkmark | Checkmark |
CheckoutUser | CheckoutUser |
ChildrensNames | ChildrensNames |
Combine | Combine |
Comment | Comment |
Comments | Comments |
Company | Company |
CompanyNumber | CompanyNumber |
CompanyPhonetic | CompanyPhonetic |
CompatibleManagedProperties | CompatibleManagedProperties |
CompatibleSearchDataTypes | CompatibleSearchDataTypes |
Completed | Completed |
ComplianceAssetId | ComplianceAssetId |
ComputerNetworkName | ComputerNetworkName |
Confidential | Confidential |
Confirmations | Confirmations |
ConfirmedTo | ConfirmedTo |
ConnectionType | ConnectionType |
ContactInfo | ContactInfo |
Content | Content |
ContentLanguages | ContentLanguages |
ContentType | ContentType |
ContentTypeId | ContentTypeId |
CorrectBodyToShow | CorrectBodyToShow |
CrawlerXSLFile | CrawlerXSLFile |
Created | Created |
Created_x0020_By | Created_x0020_By |
Created_x0020_Date | Created_x0020_Date |
CustomContentTypeId | CustomContentTypeId |
CustomerID | CustomerID |
Data | Data |
Date | Date |
DateCompleted | DateCompleted |
DayOfWeek | DayOfWeek |
DecisionStatus | DecisionStatus |
DefaultCssFile | DefaultCssFile |
Deleted | Deleted |
Department | Department |
Description | Description |
Detail | Detail |
DiscussionLastUpdated | DiscussionLastUpdated |
DiscussionTitle | DiscussionTitle |
DiscussionTitleLookup | DiscussionTitleLookup |
DisplayTemplateJSConfigurationUrl | DisplayTemplateJSConfigurationUrl |
DisplayTemplateJSIconUrl | DisplayTemplateJSIconUrl |
DisplayTemplateJSTargetContentType | DisplayTemplateJSTargetContentType |
DisplayTemplateJSTargetControlType | DisplayTemplateJSTargetControlType |
DisplayTemplateJSTargetListTemplate | DisplayTemplateJSTargetListTemplate |
DisplayTemplateJSTargetScope | DisplayTemplateJSTargetScope |
DisplayTemplateJSTemplateHidden | DisplayTemplateJSTemplateHidden |
DisplayTemplateJSTemplateType | DisplayTemplateJSTemplateType |
DisplayTemplateLevel | DisplayTemplateLevel |
DLC_Description | DLC_Description |
DocIcon | DocIcon |
DueDate | DueDate |
Duration | DLC_Duration |
Duration | |
Edit | Edit |
Editor | Editor |
Email2 | Email2 |
Email3 | Email3 |
EmailBody | EmailBody |
EmailCalendarDateStamp | EmailCalendarDateStamp |
EmailCalendarSequence | EmailCalendarSequence |
EmailCalendarUid | EmailCalendarUid |
EmailCc | EmailCc |
EmailFrom | EmailFrom |
EmailHeaders | EmailHeaders |
EmailReferences | EmailReferences |
EmailSender | EmailSender |
EmailSubject | EmailSubject |
EmailTo | EmailTo |
EncodedAbsThumbnailUrl | EncodedAbsThumbnailUrl |
EncodedAbsUrl | EncodedAbsUrl |
EncodedAbsWebImgUrl | EncodedAbsWebImgUrl |
End | End |
EndDate | EndDate |
Event | Event |
EventCanceled | EventCanceled |
EventType | EventType |
Expires | Expires |
ExtendedProperties | ExtendedProperties |
ExtranetInvitationReportDateSubm | ExtranetInvitationReportDateSubm |
ExtranetInvitationReportEmail | ExtranetInvitationReportEmail |
ExtranetInvitationReportMessage | ExtranetInvitationReportMessage |
ExtranetInvitationReportRequesto | ExtranetInvitationReportRequesto |
ExtranetInvitationReportSiteId | ExtranetInvitationReportSiteId |
ExtranetInvitationReportStatus | ExtranetInvitationReportStatus |
Facilities | Facilities |
fAllDayEvent | fAllDayEvent |
File_x0020_Size | File_x0020_Size |
File_x0020_Type | File_x0020_Type |
FileDirRef | FileDirRef |
FileLeafRef | FileLeafRef |
FileRef | FileRef |
FileSizeDisplay | FileSizeDisplay |
FileType | FileType |
FirstName | FirstName |
FirstNamePhonetic | FirstNamePhonetic |
FolderChildCount | FolderChildCount |
FormCategory | FormCategory |
FormData | FormData |
FormDescription | FormDescription |
FormId | FormId |
FormLocale | FormLocale |
FormName | FormName |
FormRelativeUrl | FormRelativeUrl |
FormURN | FormURN |
FormVersion | FormVersion |
fRecurrence | fRecurrence |
FreeBusy | FreeBusy |
From | From |
FSObjType | FSObjType |
FTPSite | FTPSite |
FullBody | FullBody |
FullName | FullName |
GbwCategory | GbwCategory |
GbwLocation | GbwLocation |
Gender | Gender |
GoFromHome | GoFromHome |
GoingHome | GoingHome |
GovernmentIDNumber | GovernmentIDNumber |
Group | Group |
GUID | GUID |
HasCustomEmailBody | HasCustomEmailBody |
HealthReportCategory | HealthReportCategory |
HealthReportExplanation | HealthReportExplanation |
HealthReportRemedy | HealthReportRemedy |
HealthReportServers | HealthReportServers |
HealthReportServices | HealthReportServices |
HealthReportSeverity | HealthReportSeverity |
HealthReportSeverityIcon | HealthReportSeverityIcon |
HealthRuleCheckEnabled | HealthRuleCheckEnabled |
HealthRuleReportLink | HealthRuleReportLink |
HealthRulesAutoRepairEnabled | HealthRuleAutoRepairEnabled |
HealthRuleSchedule | HealthRuleSchedule |
HealthRuleScope | HealthRuleScope |
HealthRuleService | HealthRuleService |
HealthRuleType | HealthRuleType |
HealthRuleVersion | HealthRuleVersion |
Hobbies | Hobbies |
HolidayDate | HolidayDate |
HolidayNightWork | HolidayNightWork |
HolidayWork | HolidayWork |
Home2Number | Home2Number |
HomeAddressCity | HomeAddressCity |
HomeAddressCountry | HomeAddressCountry |
HomeAddressPostalCode | HomeAddressPostalCode |
HomeAddressStateOrProvince | HomeAddressStateOrProvince |
HomeAddressStreet | HomeAddressStreet |
HomeFaxNumber | HomeFaxNumber |
HomePhone | HomePhone |
HTML_x0020_File_x0020_Type | HTML_x0020_File_x0020_Type |
IconOverlay | IconOverlay |
ID | ID |
IMAddress | IMAddress |
ImageCreateDate | ImageCreateDate |
ImageHeight | ImageHeight |
ImageSize | ImageSize |
ImageWidth | ImageWidth |
IMEComment1 | IMEComment1 |
IMEComment2 | IMEComment2 |
IMEComment3 | IMEComment3 |
IMEDisplay | IMEDisplay |
IMEPos | IMEPos |
IMEUrl | IMEUrl |
In | In |
Indentation | Indentation |
IndentLevel | IndentLevel |
Initials | Initials |
InstanceID | InstanceID |
IsActive | IsActive |
IsAnswered | IsAnswered |
ISDNNumber | ISDNNumber |
IsFeatured | IsFeatured |
IsNonWorkingDay | IsNonWorkingDay |
IsQuestion | IsQuestion |
IsRootPost | IsRootPost |
IsSiteAdmin | IsSiteAdmin |
IssueStatus | IssueStatus |
Item | Item |
ItemChildCount | ItemChildCount |
JobTitle | JobTitle |
Keywords | Keywords |
Language | Language |
Last_x0020_Modified | Last_x0020_Modified |
LastNamePhonetic | LastNamePhonetic |
LastReplyBy | LastReplyBy |
Late | Late |
LeaveEarly | LeaveEarly |
LessLink | LessLink |
LimitedBody | LimitedBody |
LinkDiscussionTitle | LinkDiscussionTitle |
LinkDiscussionTitle2 | LinkDiscussionTitle2 |
LinkDiscussionTitleNoMenu | LinkDiscussionTitleNoMenu |
LinkFilename | LinkFilename |
LinkFilenameNoMenu | LinkFilenameNoMenu |
LinkIssueIDNoMenu | LinkIssueIDNoMenu |
LinkTemplateName | LinkTemplateName |
LinkTitle | LinkTitle |
LinkTitleNoMenu | LinkTitleNoMenu |
List | List |
ListType | ListType |
Location | Location |
ManagedPropertyMapping | ManagedPropertyMapping |
ManagersName | ManagersName |
MasterSeriesItemID | MasterSeriesItemID |
MessageBody | MessageBody |
MessageId | MessageId |
MetaInfo | MetaInfo |
MiddleName | MiddleName |
Mileage | Mileage |
MobileContent | MobileContent |
MobilePhone | MobilePhone |
Modified | Modified |
Modified_x0020_By | Modified_x0020_By |
MoreLink | MoreLink |
MUILanguages | MUILanguages |
MyEditor | MyEditor |
Name | Name |
NameOrTitle | NameOrTitle |
Nickname | Nickname |
NightWork | NightWork |
NoCodeVisibility | NoCodeVisibility |
NoCrawl | NoCrawl |
Notes | Notes |
NumberOfVacation | NumberOfVacation |
Occurred | Occurred |
Office | Office |
OffsiteParticipant | OffsiteParticipant |
OffsiteParticipantReason | OffsiteParticipantReason |
ol_Department | ol_Department |
ol_EventAddress | ol_EventAddress |
Oof | Oof |
Order | Order |
OrganizationalIDNumber | OrganizationalIDNumber |
OtherAddressCity | OtherAddressCity |
OtherAddressCountry | OtherAddressCountry |
OtherAddressPostalCode | OtherAddressPostalCode |
OtherAddressStateOrProvince | OtherAddressStateOrProvince |
OtherAddressStreet | OtherAddressStreet |
OtherFaxNumber | OtherFaxNumber |
OtherNumber | OtherNumber |
Out | Out |
Outcome | Outcome |
Overbook | Overbook |
Overtime | Overtime |
owshiddenversion | owshiddenversion |
PagerNumber | PagerNumber |
ParentFolderId | ParentFolderId |
ParentID | ParentID |
ParentItemEditor | ParentItemEditor |
ParentItemID | ParentItemID |
ParentLeafName | ParentLeafName |
ParentVersionString | ParentVersionString |
Participants | Participants |
ParticipantsPicker | ParticipantsPicker |
PendingModTime | PendingModTime |
PercentComplete | PercentComplete |
PermMask | PermMask |
PersonalWebsite | PersonalWebsite |
PersonImage | PersonImage |
PersonViewMinimal | PersonViewMinimal |
Picture | Picture |
PostCategory | PostCategory |
Predecessors | Predecessors |
Preview | Preview |
PreviewExists | PreviewExists |
PreviewOnForm | PreviewOnForm |
PreviouslyAssignedTo | PreviouslyAssignedTo |
PrimaryNumber | PrimaryNumber |
PrincipalCount | PrincipalCount |
Priority | Priority |
Profession | Profession |
ProgId | ProgId |
PublishedDate | PublishedDate |
Purpose | Purpose |
QuotedTextWasExpanded | QuotedTextWasExpanded |
RadioNumber | RadioNumber |
RecurrenceData | RecurrenceData |
RecurrenceID | RecurrenceID |
ReferredBy | ReferredBy |
RelatedIssues | RelatedIssues |
RelatedItems | RelatedItems |
RelatedLinks | RelatedLinks |
RelevantMessages | RelevantMessages |
RepairDocument | RepairDocument |
ReplyNoGif | ReplyNoGif |
RequiredField | RequiredField |
Resolved | Resolved |
ResolvedBy | ResolvedBy |
ResolvedDate | ResolvedDate |
RestrictContentTypeId | RestrictContentTypeId |
Role | Role |
RulesUrl | RulesUrl |
ScheduledWork | ScheduledWork |
ScopeId | ScopeId |
SelectedFlag | SelectedFlag |
SelectFilename | SelectFilename |
SelectTitle | SelectTitle |
SendEmailNotification | SendEmailNotification |
ServerUrl | ServerUrl |
Service | Service |
ShortComment | ShortComment |
ShortestThreadIndex | ShortestThreadIndex |
ShortestThreadIndexId | ShortestThreadIndexId |
ShortestThreadIndexIdLookup | ShortestThreadIndexIdLookup |
ShowCombineView | ShowCombineView |
ShowInCatalog | ShowInCatalog |
ShowRepairView | ShowRepairView |
SipAddress | SipAddress |
SMLastModifiedDate | SMLastModifiedDate |
SMTotalFileCount | SMTotalFileCount |
SMTotalFileStreamSize | SMTotalFileStreamSize |
SMTotalSize | SMTotalSize |
SortBehavior | SortBehavior |
SpouseName | SpouseName |
Start | Start |
StartDate | StartDate |
StatusBar | StatusBar |
Subject | Subject |
Suffix | Suffix |
SurveyTitle | SurveyTitle |
SystemTask | SystemTask |
TagEventDate | TagEventDate |
TargetControlType | TargetControlType |
TaskCompanies | TaskCompanies |
TaskDueDate | TaskDueDate |
TaskGroup | TaskGroup |
TaskOutcome | TaskOutcome |
TaskStatus | TaskStatus |
TaskType | TaskType |
TaxCatchAll | TaxCatchAll |
TaxCatchAllLabel | TaxCatchAllLabel |
TaxKeyword | TaxKeyword |
TaxKeywordTaxHTField | TaxKeywordTaxHTField |
TelexNumber | TelexNumber |
TemplateHidden | TemplateHidden |
TemplateId | TemplateId |
TemplateUrl | TemplateUrl |
ThreadIndex | ThreadIndex |
Threading | Threading |
ThreadingControls | ThreadingControls |
ThreadTopic | ThreadTopic |
Thumbnail | Thumbnail |
ThumbnailExists | ThumbnailExists |
ThumbnailOnForm | ThumbnailOnForm |
TimeZone | TimeZone |
Title | Title |
ToggleQuotedText | ToggleQuotedText |
TotalWork | TotalWork |
TrimmedBody | TrimmedBody |
TTYTDDNumber | TTYTDDNumber |
UID | UID |
UIVersion | UIVersion |
UniqueId | UniqueId |
Until | Until |
URL | URL |
URLNoMenu | URLNoMenu |
URLwMenu | URLwMenu |
User | User |
UserExpiration | UserExpiration |
UserField1 | UserField1 |
UserField2 | UserField2 |
UserField3 | UserField3 |
UserField4 | UserField4 |
UserInfoHidden | UserInfoHidden |
UserLastDeletionTime | UserLastDeletionTime |
UserName | UserName |
V3Comments | V3Comments |
V4CallTo | V4CallTo |
V4HolidayDate | V4HolidayDate |
V4SendTo | V4SendTo |
Vacation | Vacation |
VirusStatus | VirusStatus |
WebPage | WebPage |
WF4InstanceId | WF4InstanceId |
WhatsNew | WhatsNew |
Whereabout | Whereabout |
wic_System_Copyright | wic_System_Copyright |
WikiField | WikiField |
WorkAddress | WorkAddress |
WorkCity | WorkCity |
WorkCountry | WorkCountry |
WorkFax | WorkFax |
WorkflowAssociation | WorkflowAssociation |
WorkflowDisplayName | WorkflowDisplayName |
WorkflowInstance | WorkflowInstance |
WorkflowInstanceID | WorkflowInstanceID |
WorkflowItemId | WorkflowItemId |
WorkflowLink | WorkflowLink |
WorkflowListId | WorkflowListId |
WorkflowName | WorkflowName |
WorkflowOutcome | WorkflowOutcome |
WorkflowTemplate | WorkflowTemplate |
WorkflowVersion | WorkflowVersion |
WorkPhone | WorkPhone |
Workspace | Workspace |
WorkspaceLink | WorkspaceLink |
WorkState | WorkState |
WorkZip | WorkZip |
WSDescription | WSDescription |
WSDisplayName | WSDisplayName |
WSEnabled | WSEnabled |
WSEventContextKeys | WSEventContextKeys |
WSEventSource | WSEventSource |
WSEventSourceGUID | WSEventSourceGUID |
WSEventType | WSEventType |
WSGUID | WSGUID |
WSPublishError | WSPublishError |
WSPublishState | WSPublishState |
xd_ProgID | xd_ProgID |
xd_Signature | xd_Signature |
XMLTZone | XMLTZone |
XomlUrl | XomlUrl |
XSLStyleBaseView | XSLStyleBaseView |
XSLStyleCategory | XSLStyleCategory |
XSLStyleIconUrl | XSLStyleIconUrl |
XSLStyleRequiredFields | XSLStyleRequiredFields |
XSLStyleWPType | XSLStyleWPType |
Grand Total |