Introduction
After migrating Google file links to SharePoint URLs, cross-file link references in Excel formulas may break. Excel can automatically fix these broken links within formulas when users open the Excel files after migration. For this service to function, the source Google file ID needs to be migrated and stored in a managed property named "MigrationSourceID" within the destination SharePoint or OneDrive. This guide will help you fix these links by migrating Google Source ID using a managed property named MigrationSourceID.
Note:
-
If migrating is carried out through MMP platform the source ID mapping is supported by default.
-
If migration is carried out through 3rd party tools, then it’s advised to handle the source id mapping in the 3rd party tool as described in detail below.
Steps to Migrate Google Source ID
1. Provision Managed Property for Stamping
To manage the migration process effectively, create a managed property named MigrationSourceID. This property will be used to search for items within the tenant using user consent.
-
Create the managed property at the site level and add it to your document library.
-
Once the site column is created, it will be searchable by default.
For more details, refer to: [How Do Site Columns Become Managed Properties - Microsoft Learn]
Sample Template for the Field
{
"name": "MigrationSourceID",
"FieldType": "Text",
"enforceUniqueValues": false,
"Hidden": false,
"Required": false,
"ReadOnlyField": true/false,
"text": {
"appendChangesToExistingText": false,
"maxLength": 255,
"textType": "plain"
} }
2. Set the Google Source ID at File Level
Before setting the value, ensure that the managed property MigrationSourceID is provisioned. The Google Source ID field value is supported in both SharePoint Migration API and MS Graph calls.
Using SharePoint Migration API
Set the value in the SharePoint Migration API. The field value can be set in the PRIME package during migration. See the sample below:
Using MS Graph
Set the value using MS Graph. Refer to [Update a file or folder - Microsoft Graph v1.0] for more details.
Troubleshooting Tips
-
Missing Managed Property: Ensure that the MigrationSourceID property is provisioned correctly at the site level.
-
Search Issues: Verify that the site columns are added to the document library and are searchable.
-
API Errors: Check for correct API usage and proper authorization.
Refence Links
