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


Power Automate Community User Group Member Badge

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


Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 92 members 5,479 guests
Please welcome our newest community members: