Views:

Applies to Product - Power Automate


What’s happening?
Customers are experiencing difficulties when attempting to link Microsoft Project with Power Automate, specifically when trying to set up a flow that connects a SharePoint list to a Project site. This arises when the required root site URL is not accepted, leading to errors such as "access denied" or JSON format errors.


Reason:
The errors encountered are primarily due to incorrect URL syntax or insufficient permissions to access the SharePoint site associated with the Project. The correct root site URL is necessary for establishing the connection, and access permissions must be verified.


Resolution:

  1. Ensure that the correct root site URL is being used. The expected format should resemble:
  2. https://project.microsoft.com/admin.live.unc.edu
  3. Alternatively, check if the URL for the PWA site is correct, such as https://adminliveunc.sharepoint.com/sites/pwa.
  4. If an "access denied" error occurs, verify that the user has the necessary permissions to access the SharePoint site. The user may need to be granted access by the site administrator.
  5. For the Project ID and Task Name, ensure that the correct values are being pulled from the Project URL. The Project ID can typically be found in the URL when accessing the project directly.
  6. If the flow is still not functioning as expected, consider using APIs to achieve the desired outcome, as there may be limitations with the direct actions available in Power Automate for creating tasks in Modern Project (Project for the web).