Forum Discussion

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...

P4TW

P4W

PhilippS1

Copper Contributor

Jul 14, 2023

PatrickGrebe

Hi Patrick, I am trying to implement the whole thing in PowerAutomate.

1. first I create the team.
2. wait 2min
3. add an entry in the Dataverse table "Teams" (see second screenshot)
4. after that I create the project in the table "projects" with the TeamID as owner.

I seem to be missing the step where I add the role "Project Team Member" to the team. Unfortunately I have no idea where to find this.

Do you have a hint for me please?

Here is the error message I get:
"URL was not parsed due to an ODataUnrecognizedPathException. Resource not found for the segment provided in the URL."

I think this suggests that a relation is missing to another table? Probably owner?

gbartumeu

Brass Contributor

Jul 19, 2023

Hello PhilippS1,

I did it using Power Automate.

On Dataverse, the Team table will automatically add the Team you recently created. But if you want you can add it by yourself.

Then you will need to relate this Team with Team roles associations: Project Team Memeber and Project Common.

Here is how I have done it using a "https://learn.microsoft.com/en-us/connectors/commondataserviceforapps/#relate-rows" (In Spanish..):

1. Table name: Teams

2. Row Id: Your Team Id

3. Relate: Team Role Associaton table

4. Relate with: https://[Your dynamics URL]/api/data/v9.1/roles(ROLE ID), where the role ID you should copy it from your "Team Roles" Dataverse table.

Hope it helps!!

ankitjana
Copper Contributor
Oct 11, 2023
PhilippS1 Were you able to solve this?
I am trying to achieve the same but I am not able to assign the owner when I am creating the Project using the 'Add a new row' action.
I am getting the following error
Principal with id xx-xx-xx-xx-xx does not have CreateAccess right(s) for record with id 00000000-0000-0000-0000-000000000000 of entity msdyn_project.

Thanks!
PhilippS1
Copper Contributor
Aug 01, 2023
It is really uncomfortable for me to ask, but I just can't get on here by myself and would be very happy about further help 🙂
PhilippS1
Copper Contributor
Jul 19, 2023
gbartumeu

Thank you very much for your help! I appreciate it!
Unfortunately I have no success. For me it does not create a row in the dataverse table "Table" after the creation of the team.
I have then set the entry once manually, unfortunately without success. Here once my flow:

In the actions that are used to relate the role, I used the team ID that I got from the action before. Not the team ID, which I received in the first action.
If it is not too much effort for you and you find time, could you show me your whole flow? I can understand if it is too much work though.