Showing results for 
Search instead for 
Did you mean: 
Advocate II
Advocate II

Getting Dataverse teams current canvas app user is a member of

I have created a task list where either an individual user or a team can be the owner of the task.  I would like to create a filter in a gallery to show just tasks for the current user.  I have been able to achieve this when the task is assigned to them as a user but I am struggling to do so when the task is assigned to a team they are a member of.  


Specifically I am struggling to be able to list all the teams the user is a member of.  The relationship between the teams and user dataverse tables is a many-to-many relationship, where I've tried to follow these steps to list the teams a user is a part of.  However I am getting strange behaviour where the Canvas app does not seem to acknowledge there is a relationship between the two tables at all. 


In summary, my question is how do I find the teams the current user is a member of within the context of a Canvas app?       

Super User
Super User

You can find the Groups the user owns/belongs to using the Office365Groups.ListOwnedGroupsV3() connector, which includes Teams of which they are a member. You can use the Group ID in conjunction with the Planner connector to list all tasks for a given plan if that's how you are recording tasks.


Are those the kind of teams you are after?



Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.

Hi Bryan.  I think there's some confusion on what I mean by Teams.  I am trying to refer directly to the Dataverse table called Teams which has a Many-to-Many relationship with to the Users Dataverse table.  This is separate to the O365 groups around the rest of O365.  


I am frustrated daily with Microsoft's poor generic naming of everything  

Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,132)