This article explains how to set up an integration for SharePoint list items to become tasks within OnePlan plans.
Integration Setup
To complete the OnePlan setup, you need to be an admin (user with Owner permissions) in OnePlan. If the Advanced Settings are NOT enabled, contact OnePlan for assistance.
-
Log into your OnePlan group using your OnePlan login credentials.
-
Access the Admin pages by clicking on the settings (gear) icon at the top right of the browser.
-
Navigate to the Integration section in the left-hand navigation panel.
-
Next to the Authentication Keys section click the + Add Key button.
-
Provide a descriptive name or title for the Authentication Key to denote its purpose, then click ADD.
- Store the OnePlan group name and the Authentication Key securely. This grants access to your OnePlan group for any program. Please note that the key will no longer be visible after the page is refreshed
Note: It's recommended to generate a new authentication key for every integration and assign a descriptive name to each key, enabling clear association with its corresponding integration. This practice enhances security, simplifies management, and facilitates easier tracking and troubleshooting.
-
Go to https://my.oneconnect.ai (or https://eu.oneconnect.ai for European customers utilizing eu.oneplan.ai).
-
Click on the SharePoint Lists to OnePlan Tasks integration tile. Click Configure.
SharePoint Connector
-
SharePoint URL
- Enter the SharePoint URL where the file is located (e.g., https://{OrganizationName}.sharepoint.com/sites/{SiteName}). Note: Currently, we do not support SharePoint Server.
-
Username
- Enter the username.
- Note: Ensure that the provided username does not have Multi-Factor Authentication (MFA) associated with it. It is recommended to use a dedicated service account to access the SharePoint site. Best practice dictates one service account per integration to avoid data throttling and potential strategy failures by Microsoft.
-
Password
- Enter the password.
-
(Optional - Checkbox) SharePoint Modern Authentication
- For more information on how to set up SharePoint Modern Authentication. If this box is checked, please enter the Client Id and Client Secret in the Additional Options section.
-
Additional Options
- Expand the section for additional configuration options.
-
(Optional) Client Id
- If using Modern Authentication, enter the Client ID generated from the SharePoint site.
-
(Optional) Client Secret
- If using Modern Authentication, enter the Client Secret generated from the SharePoint site.
-
SharePoint List Names to Import
- Enter the names of all lists intended for integration into OnePlan. It is crucial that these names correspond exactly to the front-end names of the respective lists in SharePoint.
-
(Optional – Checkbox) Only single list
- If importing a single SharePoint list to OnePlan, check this box. This will add the SP List ID field mapping to their integration.
-
(Optional) Email Copy To
- To include someone else that is not already being notified of this integration status, enter the email here.
-
(Optional) If you are using an Entra service principle to connect to SharePoint
- Click here to learn more about connecting SharePoint via Entra service principals.
- Expand the section called Advanced Options
- Check the "Use a Service Principal to connect to SharePoint Online" checkbox.
- Click the Authorize button. (you must be a tenant administrator to do that)
-
Test Connection
- Click Test to verify the correctness of the connection settings to SharePoint/OneDrive.
- A notification indicating Connected Successfully should appear in the top-right corner of the browser upon successful testing.
-
Save Changes
- After verifying the connection, click Save to retain the configured settings.
OnePlan Connection
-
Group Name
- Input the name of the OnePlan Group name you intend to integrate with.
-
Authentication Key
- Paste the generated OnePlan Authentication Key obtained from OnePlan.
-
Additional Options
- Expand the section for additional configuration options.
-
(Optional) Alternate OnePlan Environment URL
- If using an environment other than the default (https://my.oneplan.ai), select the appropriate URL from the available options:
-
Test Connection
-
Click Test to verify the correctness of the connection settings to OnePlan.
- A notification indicating Connected Successfully should appear in the top-right corner of the browser upon successful testing
-
-
Save Changes
-
After verifying the connection, click Save to retain the configured settings.
-
SharePointToOnePlanTasks
This strategy syncs Projects from SharePoint to OnePlan
SynchLookups
Sync list from SharePoint to OnePlan
Required Additional Field Mapping
SP List(s) to Tasks
SharePoint Field |
OnePlan Field |
Direction |
Notes |
---|---|---|---|
{Custom Column Name} |
Plan Id |
Both |
Required |
OneConnect does not have the ability to know where to assign the SharePoint list items automatically. Because of this, a custom text column needs to be made in SharePoint, and within that column, the OnePlan Plan Id. Having this field mapping will allow the SharePoint list items to come over into OnePlan as a Schedule item within the Work Plan.
To find the OnePlan Plan Id, open the Plan Details section of the plan in question, go into the Console Log of your browser, type PlanId, and press Enter. The unique plan id will appear.
Copy and paste the Plan Id into the SharePoint Plan Id Column that was created.
Integration Limitations
Integration intended for OnePlan Work Fields
This integration is intended to create task items in the Schedule Work Plan and assign values to the fields listed in the OnePlan Configuration > Work Fields section.
No other system fields or task features can be set (hierarchy, task order, dependencies, etc.).