Announcements
No record found.
Hello,
I want to to generate a list of all users along with their teams. Thing is my customer want a list of users with associated teams separated by a comma if the user is in more than one team. I am aware there isn't any OOB solution for this. But, is there any option in XrmToolBox to process this request?
Thank you
Hi Harsha.D,
As far as I know, there is no tool in XrmToolBox can do this. You have to write some code with SDK or Web API to achieve this.
Hi,
If you are familiar with Console Application C# code then you can copy paste below sample code to getlist of users with the teams -
Dictionary userTeamLists = new Dictionary(); // Get List of Users string userQuery = $@" "; EntityCollection userEntities = crmSvc.RetrieveMultiple(new FetchExpression(userQuery)); foreach (var user in userEntities.Entities) { Guid userId = user.Id; // Get List of Teams Associated to the user string teamQuery = $@" "; EntityCollection teamEntities = crmSvc.RetrieveMultiple(new FetchExpression(teamQuery)); StringBuilder teamNames = new StringBuilder(); foreach (var item in teamEntities.Entities) { string teamName = item.GetAttributeValue("name"); teamNames.Append(teamName); teamNames.Append(","); } userTeamLists.Add(userId.ToString(), teamNames.ToString()); }
If you want to export the list as cvs then you can easily convert dictionary objectto csv file.
Please mark my answer verified if this is helpful!
Regards,
Bipin Kumar
Follow my Blog: xrmdynamicscrm.wordpress.com/
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Tom_Gioielli 22 Super User 2026 Season 1
Suriyanarayanan V 22
Eugen Podkorytov 14
