web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Office365Groups.ListOw...
Power Apps
Answered

Office365Groups.ListOwnedGroupsV3 connection not working

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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

Categories:
  • v-yutliu-msft Profile Picture
    Microsoft Employee on at

    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.

    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 Power Platform Member Profile Picture
    Microsoft Employee on at

    @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

    Screenshot3.PNG
    Screenshot2.PNG
    Screenshot1.PNG
  • Verified answer
    v-yutliu-msft Profile Picture
    Microsoft Employee on at

    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 Profile Picture
    12 on at

    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 Profile Picture
    12 on at

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

  • james_hathaway Profile Picture
    427 on at

    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 Profile Picture
    4 on at

    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 Profile Picture
    94 on at

    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 Profile Picture
    427 on at

    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.

  • ErwanF Profile Picture
    94 on at

    Thats what I did just now. I had to create another group just to differentiate user role. In this case, one group is super user and another is basic user. As long as the user are in unique group as member, it should be fine. Its troublesome as I intend to manage just single group but I guess no workaround for that this time.

    ListOwnedGroupsV3 is actually not listed in documentation. Makes you wonder.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 381 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 340

#3
WarrenBelz Profile Picture

WarrenBelz 187 Most Valuable Professional

Last 30 days Overall leaderboard