When I use a Query a List control the people column value on SharePoint is returned as an integer (ID). How do I turn it into a display name or an email? What does this integer represent?
Get a display name or email from a list query
This happens when you pick users and groups.... you can only pick users in sharepoint person or group field when setting up that field.
+10
If it is configured with People Only and Allow multiple No, you will see the People Field broken down like this:
+1
What about when you need to select an office 365 group, what do you do then?
+10
have you looked at these actions?
+1
+10
The ID returned from the List people and group column is integer, but Microsoft 365 Groups has a GUID as an ID. It seems that when you USE a Microsoft 365 Group in the people and group column, SharePoint will create a dummy group with an integer id under the site groups, but you can’t get to that via the REST API, it doesn’t even come back when you ask for all Site Groups and when you make a REST API call to get members using the integer ID, you get:
{
"error": {
"code": "-2146232832, Microsoft.SharePoint.SPException",
"message": {
"lang": "en-US",
"value": "Group cannot be found."
}
}
}
May I ask if the groups you are interested in is:
- Under Microsoft 365 Admin Center
- Teams & Microsoft 365 Groups?
- Distribution List?
- Security Group?
- Under Site Permissions - Site Group (i.e. a SharePoint Group)
The groups you see in 1. above are also in AAD so that is another option.
Reply
View our Community Site Map
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.