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,
If you are familiar with Console Application C# code then you can copy paste below sample code to getlist of users with the teams -
Share
Report
All responses (
Answers (
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/
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156