Notifications
Announcements
No record found.
We are using Dynamics CRM Online and would like to obtain a list of all Teams and their members. How can I do this using Advanced Find?
Thank you.
Paul
*This post is locked for comments
Hi,
You cannot do this using Advanced find.
Teams and System users has N:N relationship, and N:N relationship entity is TeamMembership which is not visible in advanced find.
You will get Team members of single Team, but to get all teams all members, you have to use report.
In Report you can able to show Teams and members.
Hi Paul
You can't do it as an Advanced Find but you could create a quick report like the following
Use the following query in Advanced Find
That worked! Thanks much, Mark!
Sorry, Prashant, but that did not work for me. Thank you very much for the suggestion, though.
Thank you for the information, Mahadeo. I was able to obtain the team membership info by creating a report. Thanks again!
No worries, but in your question you have asked how to advance find....
Your answer was on point Prashant, it's working perfectly fine, thanks!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
SA-08121319-0 4
Calum MacFarlane 4
Alex Fun Wei Jie 2
