Forum Discussion
Any Idea to Integrated/Collaborate Project for the Web to Project Online
Hello TheophilusKevin,
This is not possible out of the box but you could look to build a Power Automate flow that did this. You would need to extend the Project for the web entity to include a field value that enabled you to associate a project to a Project in Project Online. You would need to same field and value in Project Online against the Master project - this would be the key between the data sets. The Flow could use the CDS connector to read the Project for the web data then use a SharePoint HTTP connector in Flow to call the Project Online REST API ({pwaSite}/_api/ProjectServer/) to update the Master Project. This could run on a schedule.
If you didn't need to actually update the Master Project in Project Online, you could just have the two fields that links the Project for the web projects and the Project Online project, then use Power BI to build a report to visualise the projects progress - that would be far easier.
Paul
Hello TheophilusKevin,
This is not possible out of the box but you could look to build a Power Automate flow that did this. You would need to extend the Project for the web entity to include a field value that enabled you to associate a project to a Project in Project Online. You would need to same field and value in Project Online against the Master project - this would be the key between the data sets. The Flow could use the CDS connector to read the Project for the web data then use a SharePoint HTTP connector in Flow to call the Project Online REST API ({pwaSite}/_api/ProjectServer/) to update the Master Project. This could run on a schedule.
If you didn't need to actually update the Master Project in Project Online, you could just have the two fields that links the Project for the web projects and the Project Online project, then use Power BI to build a report to visualise the projects progress - that would be far easier.
Paul