Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

filter Contacts list by CRM Access Team

I am needing to come up with a way to filter the Contact gallery/list by the Access Team the logged in user is a member of.  I am able to obtain the systemuserid of the logged in user, but I don't know how to then filter furthermore to get the teams where teamtype=1(Access) and the logged in user is part of this team.


When I do Advanced Find in CRM, I am able to get the right results (see image here), and that's the logic I was going to follow to set up the filter in PowerApps except I am not sure how to do so 2 levels drill-down.


Please help.

Thank you.


Helpful resources


Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.


Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Power Platform World Tour

Coming to a city near you


PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 311 members 2,988 guests
Please welcome our newest community members: