cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Office365Groups.ListOwnedGroupsV3 connection not working

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Office365Groups.ListOwnedGroupsV3 connection not working

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,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: Office365Groups.ListOwnedGroupsV3 connection not working

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.

5197.PNG

The result has these fields: (members information)

5199.PNG

 

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)

5198.PNG

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Regular Visitor

Re: Office365Groups.ListOwnedGroupsV3 connection not working

@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

Highlighted
Community Support
Community Support

Re: Office365Groups.ListOwnedGroupsV3 connection not working

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,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (7,739)