O365 Groups connector - all groups in org, security groups

(0) Share

Report

Posted on by RMDNA

100

Hi all,

I'm playing around with the O365 Users and Groups connectors for the first time, and I'm not finding anything in the documentation that would allow me to get info for all users in my organization, and similarly, all groups in my organization.

Assuming I have proper O365 admin permissions to be able to access that information directly through the admin portal, is there any way to get that data?

Edit: follow-up - ListOwnedGroupsV3 (which should give me groups I'm a member of) is only displaying M365 group names, not security groups. Is there a way we can accomplish that?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

zmansuri 6,048 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Give gallery's item property Office365Users.SearchUser() and all the data will be displayed in gallery

Was this reply helpful? Yes No
RMDNA 100 on at

Like (0)

Report
Copy link

Link copied!

That works great, thanks. As O365.Groups doesn't have a search action, is there a method of getting all group info?

As a follow-up question - ListOwnedGroupsV3 is only displaying M365 groups, not security groups. Is there a way we can accomplish that?

Was this reply helpful? Yes No
zmansuri 6,048 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Sorry i don't have enough permissions to test those. I barely get some data using this connectors.
There is also Azure AD Connector if you want to play around.

Was this reply helpful? Yes No
v-albai-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @RMDNA ,
By design, the Office365Group connection can only get the Microsoft 365 type group.
You can try to use AzureAD.GetMemberGroups function to get the groups you want.
For example, set the following formula in OnStart property of App, and set OwnedGroup to Items property of a dropdown to check the result.
ClearCollect(OwnedGroup,AzureAD.GetMemberGroups(User().Email,false).Value)

Note: above will return the ID of all the groups, you can then do other actions based on the selected group ID.
For example, use below to get the selected group name:
AzureAD.GetGroup(Dropdown7.Selected.Value).displayName
Or, use this to get the users who are members of the selected group:
AzureAD.GetGroupMembers(Dropdown7.Selected.Value).value
Best regards,
Allen

Was this reply helpful? Yes No