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 enabled for your group, continue to the next steps. If the Advanced Settings are NOT enabled, contact OnePlan for assistance.
-
Log in to your OnePlan group with your Office365 account.
-
Open the Admin pages by clicking on the Settings gear.
-
Select Integration in the admin navigation.
-
Click the + (plus) icon in the Authentication Keys section.
-
Save the OnePlan Group Name and the Authentication Key somewhere safe as this will give any program access to your OnePlan Group. The Key will no longer be viewable once the page refreshes.
-
Go to https://my.oneconnect.ai
-
Click on the SharePoint Lists to OnePlan Tasks integration tile. Click the Configure button.
SharePoint Section
- 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: The username must not have Multi-Factor Authentication (MFA) associated with it. Because of this, we encourage a service account to be used to access the SharePoint site. It is standard best practice to have a single service account associated with a single integration. When service accounts are connected to multiple integrations, Microsoft has been known to throttle data which can lead to strategy failures.
- 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.
- Expand Additional Options.
- (Optional) Client Id: Enter the Client ID generated from SharePoint site. To be used with the Modern Authentication checkbox.
- (Optional) Client Secret: Enter the Client Secret generated from SharePoint site. To be used with the Modern Authentication checkbox.
- SharePoint List Names to Import (Comma separated): This is where the names of all lists are entered that will be brought into OnePlan. The names need to match the front-end name of the list that will be brought over. To find the front-end name of the list, go to the SharePoint Site -> Settings icon -> click Site Contents. The list name on this page is what is typed in this box. Not the individual item name in each list.
- (Optional – Checkbox) Only single list: This box should be checked if the client does not wish to 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.
- Click Test to ensure that the connection settings to SharePoint are correct. A small notification of Connected Successfully should appear towards the top right of the page.
- Click Save.
OnePlan Section
- Group Name: Enter the OnePlan Group name you will be integrating into
- Authentication Key: Enter the OnePlan Authentication key generated from OnePlan.
- Expand Additional Options.
- (Optional) Alternate OnePlan Environment URL: If using an alternative environment than https://my.oneplan.ai, please select the appropriate URL here.
- Note: Options currently are: https://au.oneplan.ai, https://ca.oneplan.ai, https://eu.oneplan.ai
-
Click Test to ensure that the connection settings to OnePlan are correct. A small notification of Connected Successfully should appear towards the top right of the page.
-
Click Save.
SharePointToOnePlanTasks
This strategy syncs Projects from SharePoint to OnePlan
SynchLookups
Sync list from SharePoint to OnePlan
Table 3.SP List(s) to Tasks
SharePoint Fields |
OnePlan Fields |
Direction |
Notes |
---|---|---|---|
Title |
Name |
Both |
Required |
Required Additional Field Mapping
Table 4. 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.).
Comments
0 comments
Article is closed for comments.