how to resolve in sharepoint designer users from person list column that contains users and sharepoint groups

how to resolve in sharepoint designer users from person list column that contains users and sharepoint groups

https://brainstorage.wordpress.com/2013/06/14/sending-workflow-emails-to-users-or-groups-from-a-person-or-group-field/

this does return but it returns group name and usernames. I want all users from groupname saved in list column plus inidiviual

August 25th, 2015 9:46pm

Hi Amit,

Per my knowledge, SharePoint Designer workflow won't check and retrieve the users inside the SharePoint group by design.

You may want to try using SharePoint designer 2013 workflow 2013 platform with activity calling HTTP web service to retrieve users information from SharePoint group. It should be better to develop custom workflow code logic to retrieve users information.

If I misunderstood, please feel free to correct.

https://sergeluca.wordpress.com/2013/04/09/calling-the-sharepoint-2013-rest-api-from-a-sharepoint-designer-workflow/

http://sympmarc.com/2014/01/21/getting-user-information-with-the-sharepoint-2013-rest-api/

Thanks,

Daniel

Free Windows Admin Tool Kit Click here and download it now
August 26th, 2015 9:25am

Thanks Daniel.

I can see

http://social.technet.microsoft.com/wiki/contents/articles/31210.sharepoint-2013-get-user-details-from-person-or-group-field-using-rest-api.aspx

I can get only users from that column and thats fine. But now I am not able to store them and their email in dictionary.

Now I just want all users from users column in sharepoint designer rest API with their emails.

this returns result but I am not able to get d/result(0)/Email(because of multiple users-it works for single user) I can get subject and other columns.

/_api/web/lists/GetbyTitle('ourlist')/items?$select=EmailBody,Subject,ToUsergroup/EMail,CCUsersGroups/EMail&$expand=ToUsergroup/Id&$expand=CCUsersGroups/Id

From below example-

http://stackoverflow.com/questions/28104514/how-to-get-titles-of-multiple-people-or-group-columns-in-list-using-rest-api

  for(var i = 0; i< data.d.AssignedTo.results.length;i++) {
             console.log(data.d.AssignedTo.results[i].EMail); 
             console.log(data.d.AssignedTo.results[i].Name);       
         }

so in Designer I tried d/MyUserColumn/result(0)/EMail but did no

August 26th, 2015 11:22am

I can see the user collection. How to now get it next step of designer workflow as a collection?

Free Windows Admin Tool Kit Click here and download it now
August 26th, 2015 3:32pm

I figured this out with fiddler and jason. I needed another /results to get user id's. Now how to get these dictionary vairiables in for loop??
August 26th, 2015 3:50pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics