cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NoobPowerUser
Frequent Visitor

Confused about Project Online Root Site URL

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.

 

 

6 REPLIES 6
Salvopod
New Member

same, did you get a reply

anthonys123
Helper IV
Helper IV

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

bhalicki
Helper I
Helper I

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
Helper I
Helper I

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
Helper IV
Helper IV

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. 

 

Screenshot 2022-11-25 at 9.20.49 AM.png Screenshot 2022-11-25 at 9.33.19 AM.png

bhalicki
Helper I
Helper I

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.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (2,795)