Project Online
Project Online is a flexible online solution for project portfolio management (PPM) and everyday work from Microsoft. Delivered through Office 365, Project Online enables organizations to get started quickly with powerful project management capabilities to plan, prioritize, and manage projects and project portfolio investments-from almost anywhere on almost any device.
This connector is available in the following products and regions:
| Service | Class | Regions |
|---|---|---|
| Logic Apps | Standard | All Logic Apps regions |
| Power Automate | Standard | All Power Automate regions |
| Power Apps | Standard | All Power Apps regions |
| Contact | |
|---|---|
| Name | Microsoft |
| URL | Microsoft LogicApps Support Microsoft Power Automate Support Microsoft Power Apps Support |
| Connector Metadata | |
|---|---|
| Publisher | Microsoft |
| Website | https://products.office.com/project/project-management-software |
To use this integration, you will need access to an account with access to a Project Online site. To make a connection, select Sign In. You will be prompted to provide your Microsoft login, follow the remainder of the screens to create a connection.
Each of the operations require the root site URL to the Project Online site. In most cases this URL can be found in browser address bar when navigating to your Project Online site. URL should belong to sharepoint.com domain and should be PWA (Project Web App) type. If you are using Project Online through https://project.microsoft.com/ site, please visit Settings->My PWA site in order to obtain valid PWA url. E.g. https://sampletenant.sharepoint.com/teams/sampleteam
You're now ready to start using this integration.
Known issues and limitations
- The 'Resource Name' property is not returned for Project Online tasks since it is not returned by backend service's REST API itself.
- All triggers can return up to 10 items per single run. If more data is available and this is a V2 trigger, the trigger will run again without delay.
Throttling Limits
| Name | Calls | Renewal Period |
|---|---|---|
| API calls per connection | 100 | 60 seconds |
Actions
| Checkin and publish project |
Check in and publish an existing project in your site. |
| Checkout project |
Checks out an existing project in your site. |
| Create new resource |
Creates an Enterprise Resource in your Project Online site. |
| Creates new project |
Creates a new project in your project online site. |
| Creates new task |
Creates a new task in you project. |
| Get project summary task |
Gets the project summary task for a given project. |
| List project |
Lists a project by Id in your project online site. |
| List projects |
Lists the projects in your project online site. |
| Lists tasks |
Lists the published tasks in a project. |
Checkin and publish project
Check in and publish an existing project in your site.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Root Site URL
|
siteUrl | True | uri |
Root site url of your project site (Example: https://sampletenant.sharepoint.com/teams/sampleteam ). |
|
Project Id
|
project_id | True | string |
The unique id of the project to checkin. |
Returns
- response
- object
Checkout project
Checks out an existing project in your site.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Root Site URL
|
siteUrl | True | uri |
Root site url of your project site (Example: https://sampletenant.sharepoint.com/teams/sampleteam ). |
|
Project Id
|
project_id | True | string |
The unique id of the project to checkout. |
Returns
- response
- object
Create new resource
Creates an Enterprise Resource in your Project Online site.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Root Site URL
|
siteUrl | True | uri |
Root site url of your project site (Example: https://sampletenant.sharepoint.com/teams/sampleteam ). |
|
Resource name
|
Name | True | string |
The name of the new resource to create |
|
Is resource in budget
|
IsBudget | boolean |
Is resource accounted for in the budget |
|
|
Is resource generic
|
IsGeneric | boolean |
Is resource generic |
|
|
Is resource inactive
|
IsInactive | boolean |
Is resource inactive |
Returns
Project Online Enterprise Resource Model
- Body
- EnterpriseResource
Creates new project
Creates a new project in your project online site.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Root Site URL
|
siteUrl | True | uri |
Root site url of your project site (Example: https://sampletenant.sharepoint.com/teams/sampleteam ). |
|
Project name
|
Name | True | string |
Name of the new project to create |
|
Project description
|
Description | string |
Description of the new project to create |
|
|
Project start date
|
Start | date-time |
Start date of the new project |
Returns
Project Online Project Model
- Body
- Project
Creates new task
Creates a new task in you project.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Root Site URL
|
siteUrl | True | uri |
Root site url of your project site (Example: https://sampletenant.sharepoint.com/teams/sampleteam ). |
|
Project Id
|
project_id | True | string |
The unique id of the project to add the task to. |
|
Task name
|
Name | True | string |
Name of the new task to create |
|
Task notes
|
Notes | string |
Notes to put on the new task |
|
|
Task start date
|
Start | date-time |
Start date of the task |
|
|
Task duration
|
Duration | string |
Duration of the task. For example (1h, 2d, or 3w) |
Returns
Project online server task
- Body
- Task
Get project summary task
Gets the project summary task for a given project.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Root Site URL
|
siteUrl | True | uri |
Root site url of your project site (Example: https://sampletenant.sharepoint.com/teams/sampleteam ). |
|
Project Id
|
project_id | True | string |
The unique id of the project to fetch |
Returns
Project online server task
- Body
- Task
List project
Lists a project by Id in your project online site.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Root Site URL
|
siteUrl | True | uri |
Root site url of your project site (Example: https://sampletenant.sharepoint.com/teams/sampleteam ). |
|
Project Id
|
project_id | True | string |
The unique id of the project to fetch |
|
Select Query
|
$select | string |
OData select query for the columns to be returned. Example: Id, Name |
Returns
Project Online Project Model
- Body
- Project
List projects
Lists the projects in your project online site.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Root Site URL
|
siteUrl | True | uri |
Root site url of your project site (Example: https://sampletenant.sharepoint.com/teams/sampleteam ). |
Returns
Project online list projects response model
- Body
- ProjectsWrapper
Lists tasks
Lists the published tasks in a project.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Root Site URL
|
siteUrl | True | uri |
Root site url of your project site (Example: https://sampletenant.sharepoint.com/teams/sampleteam ). |
|
Project Id
|
project_id | True | string |
The unique id of the project to fetch tasks. |
|
Filter Query
|
$filter | string |
An ODATA filter query to restrict the entries returned (e.g. Id eq 'task-guid'). |
|
|
Select Query
|
$select | string |
OData select query for the columns to be returned. Example: Id, Name |
Returns
Project online list tasks response model
- Body
- TasksWrapper
Triggers
| When a new project is created |
Triggers a flow whenever a new project is created. |
| When a new project is created (V2) (Preview) |
Triggers a flow whenever a new project is created. |
| When a new resource is created |
Triggers a new flow when a new resource is created. |
| When a new resource is created (V2) (Preview) |
Triggers a new flow when a new resource is created. |
| When a new task is created |
Triggers a flow when a new task is created. |
| When a new task is created (V2) (Preview) |
Triggers a flow when a new task is created. |
| When a project is published |
Triggers a flow whenever a project is published. |
| When a project is published (V2) (Preview) |
Triggers a flow whenever a project is published. |
When a new project is created
Triggers a flow whenever a new project is created.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Root Site URL
|
siteUrl | True | uri |
Root site url of your project site (Example: https://sampletenant.sharepoint.com/teams/sampleteam ). |
Returns
Project Online on new project response model.
When a new project is created (V2) (Preview)
Triggers a flow whenever a new project is created.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Root Site URL
|
siteUrl | True | uri |
Root site url of your project site (Example: https://sampletenant.sharepoint.com/teams/sampleteam ). |
|
Select Query
|
$select | True | string |
OData select query for the columns to be returned. |
Returns
Project Online on new project response model.
When a new resource is created
Triggers a new flow when a new resource is created.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Root Site URL
|
siteUrl | True | uri |
Root site url of your project site (Example: https://sampletenant.sharepoint.com/teams/sampleteam ). |
Returns
Project Online on new resource response model.
When a new resource is created (V2) (Preview)
Triggers a new flow when a new resource is created.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Root Site URL
|
siteUrl | True | uri |
Root site url of your project site (Example: https://sampletenant.sharepoint.com/teams/sampleteam ). |
|
Select Query
|
$select | True | string |
OData select query for the columns to be returned. |
Returns
Project Online on new resource response model.
When a new task is created
Triggers a flow when a new task is created.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Root Site URL
|
siteUrl | True | uri |
Root site url of your project site (Example: https://sampletenant.sharepoint.com/teams/sampleteam ). |
Returns
Project online on new task response model
- Body
- TriggerTasksWrapper
When a new task is created (V2) (Preview)
Triggers a flow when a new task is created.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Root Site URL
|
siteUrl | True | uri |
Root site url of your project site (Example: https://sampletenant.sharepoint.com/teams/sampleteam ). |
|
Select Query
|
$select | True | string |
OData select query for the columns to be returned. |
Returns
Project online on new task response model
- Body
- TriggerTasksWrapper
When a project is published
Triggers a flow whenever a project is published.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Root Site URL
|
siteUrl | True | uri |
Root site url of your project site (Example: https://sampletenant.sharepoint.com/teams/sampleteam ). |
Returns
Project Online on new project response model.
When a project is published (V2) (Preview)
Triggers a flow whenever a project is published.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Root Site URL
|
siteUrl | True | uri |
Root site url of your project site (Example: https://sampletenant.sharepoint.com/teams/sampleteam ). |
|
Select Query
|
$select | True | string |
OData select query for the columns to be returned. |
Returns
Project Online on new project response model.
Definitions
TriggerProjectsWrapper
Project Online on new project response model.
| Name | Path | Type | Description |
|---|---|---|---|
|
Returned projects
|
value | array of TriggerProject |
The list of trigger projects returned. |
TriggerProject
Project Online Project Model
| Name | Path | Type | Description |
|---|---|---|---|
|
Project Start Date
|
ProjectStartDate | date-time |
The datetime the approved project started. |
|
Project End Date
|
ProjectFinishDate | date-time |
The datetime the approved project finished. |
|
Created Date
|
ProjectCreatedDate | date-time |
The datetime the project was created. |
|
Project Id
|
ProjectId | string |
The unique Id of the project. |
|
Last Modified Date
|
ProjectModifiedDate | date-time |
The datetime the project was last saved. |
|
Project Type
|
ProjectType | integer |
The type of the project. |
|
Project Name
|
ProjectName | string |
The name of the project. |
|
Last Published Date
|
ProjectLastPublishedDate | date-time |
The datetime the project was last published. |
|
Project Owner
|
ProjectOwnerName | string |
The owner of the project. |
|
Project Percent Completed
|
ProjectPercentCompleted | integer |
The percentage completed of the project. |
|
Project Percent Work Completed
|
ProjectPercentWorkCompleted | integer |
The percentage of work completed of the project. |
|
Project Overtime Cost
|
ProjectOvertimeCost | string |
The overtime cost of the project. |
|
Project Overtime Work
|
ProjectOvertimeWork | string |
The overtime work of the project. |
TriggerResourcesWrapper
Project Online on new resource response model.
| Name | Path | Type | Description |
|---|---|---|---|
|
Returned resources
|
value | array of TriggerResource |
The list of trigger resources returned. |
TriggerResource
Resource Online resource model.
| Name | Path | Type | Description |
|---|---|---|---|
|
Resource Id
|
ResourceId | string |
The unique Id of the resource. |
|
Base Calendar
|
ResourceBaseCalendar | string |
The base calendar type of the resource. |
|
Resource booking type
|
ResourceBookingType | integer |
Booking type of the resource |
|
Can resource level
|
ResourceCanLevel | boolean |
Can the resource level |
|
Resource cost per use
|
ResourceCostPerUse | string |
Cost per use of the resource |
|
Resource create date
|
ResourceCreatedDate | date-time |
Create date of the resource |
|
Resource earliest available from
|
ResourceEarliestAvailableFrom | date-time |
Earliest availability date of the resource |
|
Resource email
|
ResourceEmailAddress | string |
Email address of the resource |
|
Resource initials
|
ResourceInitials | string |
Initals of the resource |
|
Is resource activew
|
ResourceIsActive | boolean |
Is the new resource active |
|
Is resource generic
|
ResourceIsGeneric | boolean |
Is the new resource generic |
|
Resource latest available to
|
ResourceLatestAvailableTo | date-time |
Lastest date for which the resource is available |
|
Resource last modified date
|
ResourceModifiedDate | date-time |
Last modification date of the resource |
|
Resource name
|
ResourceName | string |
Name of the resource |
|
Resource status name
|
ResourceStatsuName | string |
Status name of the resource |
|
Resource type
|
ResourceType | integer |
Type of resource |
|
Resource type description
|
TypeDescription | string |
Description for the type of resource |
|
Resource type name
|
TypeName | string |
Type name of the resource |
TriggerTasksWrapper
Project online on new task response model
| Name | Path | Type | Description |
|---|---|---|---|
|
Returned tasks
|
value | array of TriggerTask |
The list of trigger tasks returned |
TriggerTask
Task Online Task Model
| Name | Path | Type | Description |
|---|---|---|---|
|
Project id
|
ProjectId | string |
Id of the project which the task is created in |
|
Task id
|
TaskId | string |
Id of the new task |
|
Project name
|
ProjectName | string |
Name of the project which the task is created in |
|
Task name
|
TaskName | string |
Name of the new task |
|
Task created date
|
TaskCreatedDate | date-time |
Created date of the new task |
|
Task last modified date
|
TaskModifieddate | date-time |
Last modified date of the new task |
|
Task start date
|
TaskStartDate | date-time |
Starting date of the new task |
|
Task finish date
|
TaskFinishDate | date-time |
Finishing date of the new task |
|
Task summary
|
TaskPriority | integer |
Priority of the new task |
|
Task is active
|
TaskIsActive | boolean |
Whether the task is still active |
Project
Project Online Project Model
| Name | Path | Type | Description |
|---|---|---|---|
|
Approved start date
|
ApprovedStart | date-time |
Approved project start time |
|
Approved end date
|
ApprovedEnd | date-time |
Approved project end time |
|
Checked out date
|
CheckedOutDate | date-time |
Time which the project is checked out |
|
Checkout description
|
CheckOutDescription | string |
Description which the project is checked out with |
|
Checkout id
|
CheckOutId | string |
Id of the project checkout |
|
Created date
|
CreatedDate | date-time |
Created date of the project |
|
Project id
|
Id | string |
Id of the project |
|
Is checked out
|
IsCheckedOut | boolean |
True if the project is currently checked out |
|
Last published date
|
ProjectLastPublishedDate | date-time |
Last published date of the project |
|
Last published date
|
LastPublishedDate | date-time |
Last published date of the project |
|
Last saved date
|
LastSavedDate | date-time |
Last date the project is saved |
|
Optimizer decision
|
OptimizerDecision | integer |
Project optimizer decision number |
|
Planner decision
|
PlannerDecision | integer |
Project planner decision number |
|
Project type
|
ProjectType | integer |
The type of the project |
|
Project name
|
Name | string |
The name of the project |
|
Project identifier
|
ProjectIdentifier | string |
Project identifier |
|
Win proj version
|
WinprojVersion | string |
Project version |
ProjectsWrapper
Project online list projects response model
| Name | Path | Type | Description |
|---|---|---|---|
|
Returned projects
|
value | array of Project |
The list of projects returned |
EnterpriseResource
Project Online Enterprise Resource Model
| Name | Path | Type | Description |
|---|---|---|---|
|
Can resource level
|
CanLevel | boolean |
Can resource level |
|
Resource code
|
Code | string |
Resource code |
|
Resource cost accrual
|
CostAccrual | integer |
Resource cost accrual |
|
Resource cost center
|
CostCenter | string |
Resource cost center |
|
Resource created time
|
Created | date-time |
Resource created time |
|
Default booking type
|
DefaultBookingType | integer |
Resource default booking type |
|
Email
|
string |
Resource email address |
|
|
External id
|
ExternalId | string |
Resource external id |
|
Resource group
|
Group | string |
Group which resource belongs in |
|
Hire date
|
HireDate | date-time |
Hired date of the resource |
|
Resource id
|
Id | string |
Resource id |
|
Resouce initials
|
Initials | string |
Resource initials |
|
Is resource active
|
IsActive | boolean |
Is resource active |
|
Is budget
|
IsBudget | boolean |
Is resource cost budgeted |
|
Is checked out
|
IsCheckedOut | boolean |
Is resource checked out |
|
Is generic
|
IsGeneric | boolean |
Is resource generic |
|
Is team
|
IsTeam | boolean |
Is resource part of the team |
|
Material label
|
MaterialLabel | string |
Resource material label |
|
Last modified
|
Modified | date-time |
Time which the resource is last modified |
|
Resource name
|
Name | string |
Resource name |
|
Resource phonetics
|
Phonetics | string |
Phonetic pronunciation of the resource |
|
Resource type
|
ResourceType | integer |
Resource type |
|
Termination date
|
TerminationDate | date-time |
Resource termination date |
TasksWrapper
Project online list tasks response model
| Name | Path | Type | Description |
|---|---|---|---|
|
Returned tasks
|
value | array of Task |
The list of tasks returned |
Task
Project online server task
| Name | Path | Type | Description |
|---|---|---|---|
|
Task created date
|
Created | date-time |
The created date of the task |
|
Task last modified date
|
Modified | date-time |
The last modified date of the task |
|
Task start date
|
Start | date-time |
The start date of the task |
|
Task finish date
|
Finish | date-time |
The finished date of the task |
|
Task Scheduled Start Date
|
ScheduledStart | date-time |
The scheduled start date of the task |
|
Task Scheduled Finish Date
|
ScheduledFinish | date-time |
The scheduled finish date of the task |
|
Task name
|
Name | string |
The name of the task |
|
Task id
|
Id | string |
The id of the task |
|
Task priority
|
Priority | integer |
The priority level of the task |
|
Task percent complete
|
PercentComplete | integer |
Percent of task complete |
|
Task notes
|
Notes | string |
Description notes about the task |
|
Task contact
|
Contact | string |
Contact address for the task |
|
Is Milestone Task
|
IsMilestone | boolean |
Indicates if the task is a milestone |
object
This is the type 'object'.