Forum Discussion

elmirt's avatar
elmirt
Copper Contributor
Jun 11, 2021

Add Teams group to Project for the Web with Power Automate

Hello,   we are looking for a solution to add  a Teams group to a project in "Project for the Web" with a flow.  In the web we have just to select the group and click on "Add" like in the screensh...
gbartumeu's avatar
gbartumeu
Brass Contributor

Hello PatrickGrebe,

 

I use Power Automate to update the ownerid field from the entity msdyn_project with the teamid field located in the entity "Team" but it still does not update this change on Project for the web:

 

 

PatrickGrebe's avatar
PatrickGrebe
Copper Contributor
Feb 28, 2022
I haven't tested this with a flow. However, the project creation should take place via an unbound action and the API "msdyn_CreateProjectV1". We do not update the ownerid, but maintain it directly when it is created. Here you can then set the "ownerid" directly to the team. As already mentioned, it takes 15-30 minutes before the connection is shown in P4W.

Important: If the team was newly created, a role must be added to it.
  • gbartumeu's avatar
    gbartumeu
    Brass Contributor
    Feb 28, 2022

    Hello PatrickGrebe,

     

    Thanks for your response. As you said, it took a while but now I see the project it's being assigned to the team! :stareyes:

     

    Could you explain me which role and how I must assign it to the Team? Do you refer the "team" entity record or the AAD Group?

     

    Thanks in advance,

     

     

    • PatrickGrebe's avatar
      PatrickGrebe
      Copper Contributor
      Feb 28, 2022
      Sounds good.
      We currently do it like this:

      1. Create a Microsoft 365 Group (including a Microsoft Team)
      2. Create a new record in the "team(s)" entity (connected to the AAD group created in step 1) (https://XXX.crm4.dynamics.com/api/data/v9.1/teams) .
      3. Connect the role (https://XX.crm4.dynamics.com/api/data/v9.1/roles) "Project Team Member" to the team created in step 2.

      Also see my code from the previous answer. azureactivedirectoryobjectid equals to the group id created in step 1.
      • Barend De Saeger's avatar
        Barend De Saeger
        Copper Contributor
        Jun 17, 2022

        Anyone has an idea how to give prvCreateTeam permissions to the Teams table? I've granted full permissions in the default environment Business Management Section but I keep getting below error:

        {"error":{"code":"0x80040220","message":"Principal user (Id=c2500728-e5e7-ec11-bb3c-0022489f76c6, type=8, roleCount=4, privilegeCount=256, accessMode=0), is missing prvCreateTeam privilege (Id=4807b998-6b4f-4d57-9cf6-515f50e43d79) on OTC=9 for entity 'team' (LocalizedName='Team').
        context.Caller=c2500728-e5e7-ec11-bb3c-0022489f76c6. Or identityUser.SystemUserId=d9e8da9f-e1e7-ec11-bb3c-0022489f76c6, identityUser.Privileges.Count=260, identityUser.Roles.Count=4 is missing prvCreateTeam privilege (Id=4807b998-6b4f-4d57-9cf6-515f50e43d79) on OTC=9 for entity 'team' (LocalizedName='Team')."}}

         

        EDIT:

         

        I managed to solve the issue, I'm delegating to a licensed service account but the application registration user also needed permissions on the Teams table.

Resources