Office365Groups.ListOwnedGroupsV3 connection not working

[jbon0017]

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 @jbon0017 ,

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,

[jbon0017]

@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 @jbon0017 ,

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.