Office365Groups.ListOwnedGroupsV3 connection not working

[Anonymous]

In PowerApps, I am utilizing the Office365Groups connector with the scope of checking security group memberships for users.

There are two specific operators I am interested in: Office365Groups.ListGroupMembers and Office365Groups.ListOwnedGroupsV3.

The first one is working fine but the second one is always returning blank values - tried them within same tenancy, app on same security group structure. Could someone kindly guide me on what could potentially be the problem? Maybe something in the security groups setup within the AD? And, what differs from it working in the ListGroupMembers but not in ListOwnedGroupsV3

With ListOwnedGroupsV3 I aiming to get the list of security groups a user is either owning or belonging to as specified in official documentation: https://docs.microsoft.com/en-us/connectors/office365groups/#list-groups-that-i-own-and-belong-to

[v-yutliu-msft]

Hi @Anonymous ,

1)Office365Groups.ListGroupMembers

The syntax:

Office365Groups.ListGroupMembers("groupid").value

My example:

Office365Groups.ListGroupMembers("451fd282-dxxxx").value

 This function will return all the group members based on the group id that you fill in the formula.

You could find the group id that you want in ad azure profile.

The group's object id represents the group's id.

The result has these fields: (members information)

2)Office365Groups.ListOwnedGroupsV3

The syntax:

Office365Groups.ListOwnedGroupsV3().value

 This function will return all the groups that you own and belong to.

The results has these fields: (groups information)

Best regards,

[Anonymous]

@v-yutliu-msftthanks for your feedback.

Apologies if I haven't explained my issue well. So I am using the operators in the suggested syntax already (as per the official documentation).

The operator covered in point 1) is working fine for each group id - see screenshot 1.

However point 2) is not returning any data. The request is being done well as can be seen form screenshot 2 - because I have not included .value to check that - and used only Office365Groups.ListOwnedGroupsV3() - but when opening the value in the collection itself, it is blank as per screenshot 3. How come the user with the same user principal name is showing in screenshot 1 but then not returning results in screenshot 3?

Thanks

[v-yutliu-msft · Accepted solution]

Hi @Anonymous ,

1)Please use the formula that I mentioned:

Office365Groups.ListGroupMembers("groupid").value

Office365Groups.ListOwnedGroupsV3().value

 If you not use .value, you could not check data directly.

2)Office365Groups.ListGroupMembers is used to list users in a group.

Office365Groups.ListOwnedGroupsV3 is used to list groups of current user.

These two functions have different feather.

mail in Office365Groups.ListGroupMembers function returns is user email.

mail in Office365Groups.ListOwnedGroupsV3 function returns is group email.

User email and group email is different.

Best regards,

[Spata]

Hi,

I am using the Office365Groups.ListOwnedGroupsV3 connector as you have guided, but for some reason it is not returning any data. Sometimes when I refresh the connection it works once, but then it stops working. Any ideas what could be the problem?

[Spata]

It seems like V3 of ListOwnedGroups are not working at all when using it in Customizing Sharepoint Forms. V2 is working correctly.

[james_hathaway]

I too am just receiving an Empty collection for the results of 

Office365Groups.ListOwnedGroupsV3().value

And yet I know that I am a member of many Groups...

@v-yutliu-msft - Are you sure that this functionality actually works?

James.

[Ben-Gong-2022]

I am having a slightly different problem. Using Office365Groups.ListOwnedGroupsV3().value, some uses can see their groups and distribution lists but some cannot. Does anyone have any idea as to why?

Thanks,

[ErwanF]

Same issue, V3 seems not returning the group that I own and users that I grant the ownership. Group type is 365 not security. Not sure if it has anything to do with. And V2 is consistent.

[james_hathaway]

Yeah, since I did not get any response from Microsoft, and with further testing, I have concluded that this functionality does NOT work as advertised, at least NOT RELIABLY. Just yet another example of Microsoft releasing functionality that is full of bugs, yet advertised as working.

I have found that it is much more robust to just:

1. Create a list of the groups I want to check against
2. Get the members of each of these Groups (requires Group membership visibility to be public for each group)
3. Check to see if the Current User is one of those members
   1. If it is, add to a collection "myGroups"

I then get a collection of "myGroups" to replicate the supposed functionality of the ListOwnedGroupsV3.

It is annoying that you have to waste precious seconds iterating and fetching a load of data that you don't really need (all the other members of the Groups) but its the only real way to sure of getting an accurate list of Groups I am a member of.

A Bonus consequence of this method is that is does not actually rely on the "Currently logged in User", but instead just checks membership against a string (either mail, UPN or displayName)

This allows us Developers to add a (hidden?) ability to "impersonate" a different User, and fetch the Groups that the impersonated user is a member of - very handy for testing permission/group based functionality in your app without actually having to log in as a different User!

James.