Retrieving the AAD Group Teams for a connected user

(0) Share

Report

Posted on by HFG

516

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-canvas-app/td-p/1219484 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

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (1)

v-bofeng-msft on at

Like (0)

Report
Hi @HFG ,

You could try:

Office365Groups.ListOwnedGroupsV3().value

or

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

Best Regards,

Bof

Was this reply helpful? Yes No
HFG 516 on at

Like (0)

Report

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

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report
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

Was this reply helpful? Yes No
HFG 516 on at

Like (0)

Report

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 ?

Was this reply helpful? Yes No
Verified answer

HFG 516 on at

Like (0)

Report

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

Was this reply helpful? Yes No