Get a display name or email from a list query

  • 15 November 2023
  • 2 replies

Badge +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 16 November 2023, 00:14

View original

2 replies

Userlevel 3
Badge +11

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

Badge +5

@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: