why "Office365Groups.ListGroups().value" does not return all the related office 365 security groups

(0) Share

Report

Posted on by johnjohnPter

2,002 Season of Giving Solutions 2025

I have this code inside my onvisible property of a screen:-

Set(varGroupName,If(IsProd.Run().isprod,"PPM-Maintenance Managers","PPM-Maintenance Managers-Test"));
Set(testList,Office365Groups.ListGroups().value);
With(
{
wAdminID: LookUp(
Office365Groups.ListGroups().value,
displayName = varGroupName
).id
},
Set(
varIsMainenanceManager,
Lower(User().FullName) in Lower(Office365Groups.ListGroupMembers(wAdminID).value.displayName)
)
);

now this Office365Groups.ListGroups().value does not return all the security groups.. for example i have those 2 identical security groups:-

the first group will not get returned while the second one will get returned , although both of them are security groups without emails and i am login using office 365 admin user.. any advice?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Sunil Kumar Pashikanti 2,097 Moderator on at

Like (2)

Report
Copy link

Link copied!
Hi @johnjohnPter,

The Office365Groups.ListGroups() function may not return all the security groups in your tenant, especially if you have more than 100 groups. This is because the function has a limit of 100 records and does not support pagination or filtering.

Some possible workarounds are:
Use the Office 365 Users connector and the Azure AD connector to get the list of all groups, including distribution lists.
Use the Search() function to filter the groups by a text input, such as description or display name.
Use the Office365Groups.ListGroupMembers() function with the group ID to get the members of a specific group.

Best Regards,
@SunilPashikanti

Was this reply helpful? Yes No
johnjohnPter 2,002 Season of Giving Solutions 2025 on at

Like (1)

Report
Copy link

Link copied!

@SunilPashikanti thanks for the reply, i did a Search and abel to get all the related groups,,thanks

Was this reply helpful? Yes No