Retrieving the AAD Group Teams for a connected user

[HFG]

Hi all, 

I am building a canvas app connected to Dataverse. I have created Teams connected to AAD Groups to managed the users access to data. I would like to be able to retrive the information about which teams a user belongs to to show it in the app. I have seen this post https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Retrieve-logged-in-User-associated-teams-in-... that shows how to get owning groups but I can't figure out how to get AAD Groups. The only view available is "All AAD Groups". Can anyone help ?

Thanks

[v-bofeng-msft]

Hi @HFG ,

You could try:

Office365Groups.ListOwnedGroupsV3().value

or 

AzureAD.GetMemberGroups(User().Email,false).Value

Best Regards,

Bof

[HFG]

Hi @v-bofeng-msft , 

Thanks for your reply. 

Regarding Office365.ListOwnedGroups, unless mistaken this only gets the groups that the user is the owner of. I need to list the groups the owner is a member of. I see there is the option GroupesOffice365.ListGroupMembers, but as I have 20+ teams and this amount can grow I will need to find a way to check them all dynamically. I have a table with all the AD Group GUIDs, I tried putting them all in

a collection then using forall to get the group members but there is an error message saying the O365Groups cannot be used with ForAll.

Regarding the Azure AD connector, to use it requires authorisation from an administrator and the account being used in the connector needs AD admin permissions so I think this is out of the question for us. 

As my AAD groups are linked to Teams in the environment I was hoping there was a way to list all of the teams a user is the member of. 

Thanks

[v-bofeng-msft]

Hi @HFG ,

Maybe you could use graph API to get the groups user belongs to. You could use flow or create a custom connector to invoke the graph API. It only needs read permission.

https://graph.microsoft.com/v1.0/users/{UserEmail}/transitiveMemberOf/microsoft.graph.group

https://learn.microsoft.com/en-us/graph/api/user-list-memberof?view=graph-rest-1.0&tabs=http

Best Regards,

Bof

[HFG]

HI @v-bofeng-msft , 

Thanks again for your input. 

I just retried Office365.ListOwnedGroupsV3 (I think I didn't used V3 the first time) and it does seem to get groups a user is the member of too, but only Office365 groups. I should have specified that the groups I'm trying to retreive are AAD Security Groups. Does this change anything for the information you haev given ?

[HFG · Accepted solution]

I just found how to do this, here is the code. In the example I save the teams in a one column collection colTeams. I am working in French so the exact code will change. The "Utilisateurs" table in English I believe is Users (systemusers).