Retrieve logged in User associated teams in canvas app

[GuruJetti]

Hello All,

Could you please advise me on the below requirement and i have tried some options but couldn't get the expected results. In Dataverse we have table named "Teams", i want to display the teams that are associated to current logged in user. For instance we have users x ,y and z, they have access to teams  X => abc , X => xyz  and Y=>xyz , Z=>bbc

expected result is when X logged in on Canvas app , we need to show abc and xyz team names in the dropdown and filter the gallary to show the items related to selected team. Please do let me know more details needed for the same and appreciate the suggestions.

[cchannon]

User and Team are related by an N:N intersect entity called teammembership. Team membership has an attribute "systemuserid" and another attribute, "teamid" which are pointers to the related records. 

So, if you query for all teammembership rows where systemuserid == {current user id} then the teamid values on those rows are all teams which this user is a member of.

[MayankP]

Hello,

I guess you could this using out of box view settings as shown in screen print below..

so I just put gallery control and selected data source as Teams (which should display all teams) and then filter data view as shown in screen print above...

refer this article for further information https://debajmecrm.com/filter-gallery-in-canvas-app-dynamically-on-cds-entity-views/

[GuruJetti]

Thanks for the response @cchannon , will try it

[GuruJetti]

Thanks for the response @MayankP  , will try it and i need to display these in the dropdown and selected owner team records will be displayed in the Gallary. Looking to Bind the teams view to Dropdown.

[MayankP · Accepted solution]

@GuruJetti  I guess it is same or similar for drop down..

so put this as filter on dropdown ....Filter(Teams, 'Teams (Views)'.'My Owner Teams') [as shown in screen print above]

[GuruJetti · Accepted solution]

Thanks @MayankP , i did the same and working as expected.

[DM1804]

Hi @cchannon - please share code sample for better understanding