This item.Fields[3] is from a column type PersonOrGroup. How can I get access to the persons name and email address from it? With this snippet item.Fields[3].Value.ToString() I get some numerical value (124)… Help please !!
Can you highlight the “For Each List Item” activity and take a screenshot of it? I’d like to see the properties.
This is still an open issue… I appreciate if someone could help.
Okay, the properties looks good.
I did a little bit of research and I found that for column types of “Person or Group”, the field does not return the display value (which is what you see as the person’s name or email address), but rather returns the LookupId of the FieldValueSet that references the actual value.
FieldValueSet - Microsoft Graph v1.0 | Microsoft Learn
To get the value, you’d probably have to query the API with a custom code and pass the LookupId (the numeric value you got) as the query parameter to get the name or email of the person.
Here’s a query I did with Graph Explorer with an example of my own:
The response I got when I passed E_x002d_MailLookupId & E_x002_Mail as the select query parameters, signifying the LookupId of Person object and the email value itself.
Using get list items or for loop you can get only the lookup id …but not the actual name…to get the name values you have to use the sharepoint list containing all the user details or use a graph api directly to get the details…this is a limitation in current activity
Cheers
1 Like