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?
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?
Bryan
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