I was able to get details from people and groups using rest api and with the help of the below link.


But i am not able to figure out how to extract country and city column from people and groups column.

https://mydomain.sharepoint.com/sites/eforms/hrd//_api/web/lists/getbytitle('Mid-Year Review')/Items?$select=ID,Title,City,Office,Department,Country,Division/Title, Employee/FirstName,Employee/LastName&$expand= Division/ID,Employee/ID

the above gives all but country and city details. How do i get that details as well.

  • You want get Employee country?
    – Amos
    Aug 6, 2020 at 7:54

1 Answer 1


Not all user profile properties that we could get from people column. enter image description here


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.