Automating Dataverse Team Group Creation

[ezFlow]

Hi Everyone,
AAD Security group can be assigned to Dataverse Team Group AAD manually.
Is there a way to automate the process? We have seperate Teams that Manage Azure Security and Dataverse Security. It would require some effort of coordinating to get/add create AAD SG --> Get the Security Identifier and have the other Teams use it when creating Dataverse Team Group?

[EricRegnier · Accepted solution]

Hi @ezFlow,

Yes you can automate with by script like with PowerShell, but my preference is with Power Automate. In Power Automate you can sync the teams on a schedule or when a group is created, depending on your needs. Use the Graph API to get the desired groups with the HTTP connector and use the Dataverse connector to create/set the team and group Object ID. You can use the Graph Explorer to build and test the query. 

You might initial need to work with the other team to get consent/right to use Graph if not already done. I use a service princpal to connect to graph via Power Automate. Here's a example:

1. Using the HTTP connector, to get the groups, here I get all the groups. I use Acticee Directory OAuth to authenticate. 
2. Then I parsed the body from the reponse to get the intellisense and creating a new Team in Dataverse. I set the team name and Object ID from the response.

Hope this makes sense!