MGDC for SharePoint: New Columns in September 2026

Microsoft

Sep 02, 2026

The MGDC for SharePoint team continues to improve the available datasets. This time around, we are introducing additional columns to some of our existing datasets. Here is a summary based on the different scenarios they support:

Archive – Extends support for the SharePoint Archive feature. Includes a site property for size of archived files and a file property to indicate that the file is archived.
E-signature – Supports the E-signature by adding a file to indicate there is a digital signature and the provider’s name.
Filtering – The RootWebTemplateId was added to SharePoint Groups and SharePoint Permission dataset to facilitate filter by type of site, like it is currently available for Sites, Files and File Actions.
Hub Site – Extends support for Hub Sites, introducing a column for ParentHubSiteId, to represent a hub site hierarchy.
Restricted – Multiple columns indicating restricted flags in sites, including Restricted Access Control (RAC), Restricted Content Discovery (RCD) and Restricted Content Org-wide Search Policy.
Retention – Support a set of file properties about Retention Labels, including label name, type, who applied it and when it was applied.
Sharing – Extends the SharePoint Permissions properties to support the new sharing model. This includes information about the Main Link and Variants.
Versions – Extends support for versions, including version storage metrics and version history policy.

Here is a summary of all 26 columns in 4 datasets (Sites, Groups, Permissions and Files):

Dataset	Column	Data type	Description
Sites	ArchiveStorageUsed	Number	Total size of all archived storage in bytes
Sites	IsRestrictContentOrgWide SearchPolicyEnforcedOnSite	Boolean	Restricted Content Org-wide Search Policy
Sites	IsRestrictedAccess ControlPolicyEnabled	Boolean	Restricted Access Control
Sites	IsRestrictedContentDiscovery forCopilotAndAgentsEnabled	Boolean	Restricted Content Discovery
Sites	ParentHubSiteId	String, GUID	Parent hub site for this hub site
Sites	StorageMetrics, VersionCount	Number	Number of versions
Sites	StorageMetrics, VersionSize	Number	Total size of versions in bytes
Sites	StorageMetrics, VersionMetadataSize	Number	Total size of version metadata in bytes
Sites	VersionHistoryPolicy	String	Version history policy. Possible values: None, Automatic, Manual. If manual, uses “major version limit”.
Sites	MajorVersionLimit	Number	Limit for number of major versions
Groups	RootWebTemplateId	Number	Root web template id
Groups	Description	String	Description of the group
Permissions	RootWebTemplateId	Number	Root web template id
Permissions	SharingVariant	String	Sharing link variant. Possible values include: None, PasswordProtected, TrackLinkUsers, Embeddable, Ephemeral, RestrictToExistingRelationships, MainLink, NonDurableRedeem. Multiple values can be set at once.
Permissions	MainLinkAudience	String	Main link audience. Possible values include: Organization, Empty (people with existing access).
Permissions	MainLinkRole	String	Main link role. Possible values include View, Edit, others.
Files	RetentionLabel	Object	Retention label
Files	RetentionLabel, AppliedByEmail	String	Email of user who applied retention label
Files	RetentionLabel, AppliedByName	String	Name of user who applied retention label
Files	RetentionLabel, AppliedTime	DateTme	Time when retention label was applied
Files	RetentionLabel, Name	String	Name of retention label
Files	RetentionLabel, Type	String	Type of retention label. Possible values: Normal, Record or Regulatory Record
Files	HasDigitalSignature	Boolean	File has a digital signature
Files	DigitalSignatureProvider	String	Name of digital signature provider if digital Signature exist
Files	IsFileArchived	Boolean	File is Archived

These changes are non-breaking, which means that your existing pipelines will continue to run. We also let this change sit for 21 days, so that delta datasets are also not impacted.

Anyone starting fresh with MGDC for SharePoint will automatically get the new columns in their pipelines. If you have existing pipelines and want to use the new columns, you will need to update your MGDC application, get that update approved and then update your pipeline to pull the new schema.

For more details about updating your pipelines to include new columns, or to see how these can be leveraged in specific scenarios, see these articles: