What is the MS Graph API equivalent to retrieve expanded user information from a SharePoint list item?

Question

What is the MS Graph API equivalent to retrieve expanded user information from a SharePoint list item?

Ivan Tioh 136

I used to use the following REST API to retrieve the SharePoint list item's user's title, username and email:

https://xxx.sharepoint.com/sites/xxx/_api/web/lists(guid'xxx')/items?$select=ID,UserColumn1/EMail,UserColumn1/UserName,UserColumn1/Title&$expand=UserColumn1

I've attempted to use the following Graph API but can only get the Title:

https://graph.microsoft.com/v1.0/sites/xxx,xxx/lists/xxx/items/xxx?expand=fields(select=Id,Title,UserColumn1/EMail,UserColumn1/UserName,UserColumn1/Title)

What would be the actual equivalent in MS Graph API to get the same information? Or is this limitation of Graph API which does not support so?

Thank you!

Answer accepted by question author

0 additional answers

Your answer

Answer 1

RaytheonXie_MSFT 40,496 Microsoft External Staff

Hi @Ivan Tioh

If UserColumn1 is a multi-valued user field, then the following query:

https://graph.microsoft.com/v1.0/sites/{site-id}/lists/{list-id}/items?$expand=fields($select=UserColumn1)

This API returns email and id properties along with displayName property for user field value. While for single-valued user field only id (available via {userfield}LookupId property) and displayName properties could be requested via items endpoint, for example:

https://graph.microsoft.com/v1.0/sites/{site-id}/lists/{list-id}/items?$expand=fields($select=UserColumn1,Usercolumn1LookupId)

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Ivan Tioh 136

Hi @RaytheonXie_MSFT ,

Thank you for the pointer.

I've tried the following for multi-valued user field:

https://graph.microsoft.com/v1.0/sites/xxx,xxx/lists/xxx/items/xxx?expand=fields(select=Id,Title,MultiUserColumn1)

And managed to get

 "MultiUserColumn1": [
            {
                "LookupId": xxx,
                "LookupValue": "xxx",
                "Email": "xxx"
            },
            {
                "LookupId": xxx,
                "LookupValue": "xxx",
                "Email": "xxx"
            }
        ]

Is it correct to say that:

LookupId -> ID
LookupValue -> Display name
Email -> Email

If yes, how about username? Which may look something like this: xxx#EXT#@xxx.onmicrosoft.com

For single-valued user field:

https://graph.microsoft.com/v1.0/sites/xxx,xxx/lists/xxx/items/xxx?expand=fields(select=Id,Title,UserColumn1,UserColumn1LookupId)

    "fields": {
        "@odata.etag": "xxx",
        "id": "xxx",
        "UserColumn1": "xxx",
        "UserColumn1LookupId": "xxx"
    }

I don't see any email or display name being returned. Any idea?

RaytheonXie_MSFT 40,496 Reputation points Microsoft External Staff

2023-05-04T06:08:08.4233333+00:00

Hi @Ivan Tioh

The api will only return email, the api is unable to retrieve username
Ivan Tioh 136 Reputation points

2023-05-08T03:48:15.7533333+00:00

Hi @RaytheonXie_MSFT ,

Thanks for the clarification.

Share via

What is the MS Graph API equivalent to retrieve expanded user information from a SharePoint list item?

0 additional answers

Your answer