Jun 11 2021 07:32 AM
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 screenshot:
Now we have a flow which creates a Teams team (it works fine) and we want to add the created team to a project in PftW.
We tried it with the standard Dataverse connectors but didnt find the correct field for this:
We also checked the new API: https://docs.microsoft.com/en-us/dynamics365/project-operations/project-management/schedule-api-prev...
Is it possible to add a team to the project with a flow?
Thanks in advance
Elmir
Jan 11 2022 03:36 AM
Jan 21 2022 12:00 AM
Feb 02 2022 10:16 AM
@elmirt Did you find a solution to this issue. We are also trying to find an automated way to integrate in teams.
Feb 03 2022 03:02 AM - edited Feb 03 2022 03:02 AM
@elmirt We are in the same situation. If you do this via the web interface, the "ownerid" and "owningteam" values are updated in the "msdyn_projects" entity.
The AAD group is then connected to a team (entity teams). If I do the whole thing via HTTP-PATCH, the attributes are also set accordingly, but the group is still not displayed as connected in the web interface.
Feb 25 2022 01:38 AM - edited Feb 25 2022 01:39 AM
We have now solved the whole thing using an Azure Function (within a Logic App) and corresponding C# code.
We create a team and link it to an AAD group. The team is then assigned the appropriate security role. (https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/developer/org-service/sa...)
var projectteam = new Entity("team", Guid.NewGuid());
projectteam["name"] = officeGroupName;
projectteam["businessunitid"] = new EntityReference("businessunit",Guid.Parse("GUID_BUSINESSUNIT_HERE"));
projectteam["azureactivedirectoryobjectid"] = officeGroupId;
projectteam["teamtype"] = 3;
projectteam["membershiptype"] = 0;
projectteam.Id = crmServiceClient.Create(projectteam);
// Add the role to the team.
crmServiceClient.Associate(
"team",
projectteam.Id,
new Relationship("teamroles_association"),
new EntityReferenceCollection() { new EntityReference("role", Guid.Parse("SEC-ROLE-GUID-HERE")) });
We then create the project with the API "msdyn_CreateProjectV1". Here we then set the "ownerid" to the ID of the created team.
project["ownerid"] = new EntityReference("team", Guid.Parse(projectteam.Id.ToString()));
It takes some time until the connection is shown in P4W.
Feb 25 2022 10:10 AM
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:
Feb 28 2022 03:02 AM
Feb 28 2022 03:10 AM
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!
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,
Feb 28 2022 06:47 AM
Jun 17 2022 04:58 AM - edited Jun 17 2022 05:20 AM
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.