Get groups I am the owner of

[zdieter]

Hi,

I am trying to get all the groups I am the owner of but need more than just office groups (or I could use Office365Groups connector). I am trying the AzureAD connector but that just gets groups you are a member of not owner. Is there anything I am missing or should I create a custome connector (or is there one I can use already made)?

Thank you for your time.

[RezaDorrani]

Hi @zdieter 

Office365Groups.ListOwnedGroups().value will only give you Office 365 groups

I dont think there is a direct option to fetch all Azure AD groups

Customer connector and graph api might be your best bet

Regards,

Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[v-xida-msft · Accepted solution]

Hi @zdieter ,

Do you want to get all Groups which you are the owner of, but not only just Office 365 Groups?

Currently, the Office365Groups.ListOwnedGroupsV2() formula or Office365Groups.ListOwnedGroups() formula could only list all Office 365 groups you are the owner of, it could not list other types of Groups.

If you want to get all Groups which you are the owner of, but not only just Office 365 Groups, I afraid that there is no direct way to achieve your needs in PowerApps curretly.

As an alternative solution, you could consider create a custom connector based on the Microsoft Graph Rest API within your PowerApps to achieve your needs.

Within your custom connector, you may need to specify two actions -- 'List Groups' action and 'List Owners' action. Firstly, you need to retrieve all groups defined in your Org via executing the 'List Groups' action. Then based on the retrieved groups ids, execute the 'List Owners' action, check if the returned Owners list of a specific group contains yourself. If true, the collect the corresponding group into a Collection (using Collect function). I also think the ForAll function may help in your scenario.

More details about the ForAll function, please check the following article:

ForAll function

Best regards,