search

MicrosoftDocs / microsoft-365-community

Microsoft 365 community contributed documentation https://docs.microsoft.com/microsoft-365/community/
MIT License
190 stars 163 forks source link

SharePoint Online - system field mapping (internal name to display name) #842

Open lar404 opened 11 months ago

lar404 commented 11 months ago

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.

sympmarc commented 11 months ago

@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?

sympmarc commented 11 months ago

Alternatively, you could use PowerShell to export the DisplayName / InternalName plus any other information you might want. See: Get-PnPField

lar404 commented 11 months ago

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.

sympmarc commented 11 months ago

@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
EMail EMail
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