Confused about Project Online Root Site URL

[NoobPowerUser]

First time ever posting here so please forgive an etiquette mistakes.

We're trying to create a MS Forms that will create a new project. I have tried everything I can think of as the Root Site Url.

In the PA example is sampletenat.sharepoint.com/teams/sampleteam here it says to use the PWA. 

https://docs.microsoft.com/en-us/connectors/projectonline/ and that is https://XXXXXX.sharepoint.com/sites/pwa. I gave myself admin access to the /pwa site but don't see any of the projects I see in https://project.microsoft.com/en-US/ .

I'm just very very confused . 

Any help would be greatly appreciated.

[Anonymous]

same, did you get a reply

[anthonys123]

Same problem here. Have you found a solution to this?

[bhalicki]

Hi Microsoft, can you please provide a solution?  The documentation isn't clear.  I assume we need to use the PWA, however, my default PWA doesn't even exist.

[bhalicki]

Hi, for anyone else struggling with this one and comes across this post...

Microsoft Project for the web (Project Plan 1) and Microsoft Project Online (Project Plan 3) are two separate products.  Project for the web uses the dataverse, whereas Microsoft Project Online doesn't seem to.  When you purchase a license for Microsoft Project Online, you can go into the Sharepoint Admin centre and create a new 'Project Web App Site'.  This creates a Sharepoint site and the URL is what you use as the Root Site URL.  The Power Automate connector works with Project Online, not Project for the web.

Hope that clarifies.  The Microsoft product landscape and documentation drives me insane.

[anthonys123]

To add to @bhalicki , the proper connector is Dataverse. I've found that Project for the web is actually just storing data in Datavere in different tables; Project Tasks, Projects, and Users seem to be most relevant.  

I created a workflow that sends out an email when a task is completed. I haven't finished testing to get all the proper feedback though. For instance, I got stuck trying to get the name of the person who completed the task. I keep getting completed by Microsoft Project.  

This document provides some details on the Tasks table https://learn.microsoft.com/en-us/power-apps/developer/data-platform/reference/entities/task

Anyway, I haven't tried it but I would guess that to create a task you'd do so using Add a New Row. 

 

[bhalicki]

Hi @anthonys123 , the only field in Dataverse table msdyn_projecttasks that seems to relate to the actual person who completed the task is 'Owner'.  Created_By and Modified_By both seem to store 'Microsoft Project' (presumably the owner of the process updating the task).

On a side note, have you tried to insert a new row into msdyn_project table (either manually, or using a flow)?  It always seems to fail for me, presumably as some keys are invalid, but the errors don't tell me which key is failing so it's not helpful at all.

Kind regards,

Ben.

[gianlucas]

What a answer! It really worked for me!

After trying using Dataverse APIs I was able to extract information of my projects.

Thank you.

[Pion_G]

---

@anthonys123 wrote:

the proper connector is Dataverse. I've found that Project for the web is actually just storing data in Dataverse in different tables; Project Tasks, Projects, and Users seem to be most relevant.  

I dont even have any "Project Tasks" table.

Worse, event if I've selected "English" as display language in my PA settings the "change type" options of the connector are in French: 

So, I've chosen "Mettre à jour" (French for "update") for it, but all the table names in the drop down box are also in French!
Anyway, I've selected the one which seem the closest of "Project Tasks" ("Tâches du projet"), saved the flow, created a task in our group Project but the flow didn't trigger. 

[Pion_G]

---

@Pion_G wrote:

---

@anthonys123 wrote:

the proper connector is Dataverse. I've found that Project for the web is actually just storing data in Dataverse in different tables; Project Tasks, Projects, and Users seem to be most relevant.  

Anyway, I've selected the one which seem the closest of "Project Tasks" ("Tâches du projet"), saved the flow, created a task in our group Project but the flow didn't trigger. 

---

Sorry, I didn't wait long enough
It triggered now
Now I've to filter on the project name and identify the change (I'm just looking for added tasks BTW)