Skip to main content
Nintex Community Menu Bar
Solved

Get a display name or email from a list query

  • November 15, 2023
  • 6 replies
  • 279 views
  • Translate

Forum|alt.badge.img+9

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? 

 

Best answer by Deon

@igorsp , I would say it is because the column is configured in SP to allow People and Groups.
If it is configured with People Only and Allow multiple No, you will see the People Field broken down like this:

 

 

View original
Did this topic help you find an answer to your question?

Forum|alt.badge.img+15

This happens when you pick users and groups.... you can only pick users in sharepoint person or group field when setting up that field. 

Translate

Deon
Forum|alt.badge.img+10
  • Rookie
  • November 15, 2023

@igorsp , I would say it is because the column is configured in SP to allow People and Groups.
If it is configured with People Only and Allow multiple No, you will see the People Field broken down like this:

 

 

Translate

Forum|alt.badge.img+1
  • Novice
  • January 29, 2024

What about when you need to select an office 365 group, what do you do then?

@Deon @brandiwoodson 

Translate

Deon
Forum|alt.badge.img+10
  • Rookie
  • January 30, 2024

@jr123456 ,

 

have you looked at these actions?

 

 

 

Translate

Forum|alt.badge.img+1
  • Novice
  • January 30, 2024

@Deon Can I input the ID of a 365 Group outputted from the Query a List action or how do you get a particular group?

Translate

Deon
Forum|alt.badge.img+10
  • Rookie
  • January 30, 2024

@jr123456 , it seems there are now so many different types of Groups in Azure and SharePoint.

 

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:

  1. Under Microsoft 365 Admin Center
    • Teams & Microsoft 365 Groups?
    • Distribution List?
    • Security Group?
  2. 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.

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings