topic RE: SharePoint List Skill in Product Forum

SharePoint List Skill

MounikaBanda — Fri, 10 Jul 2020 11:42:00 GMT

Hi,
When i try to extract data from a list in Share point for the field type- Person or group, I get it's Id but not the value in the extracted collection. Is there any way to get it's value or map the id to it's value?
Thanks in Advance!

------------------------------
Mounika Banda
------------------------------

RE: SharePoint List Skill

AlexanderMarlow — Fri, 31 Jul 2020 21:18:00 GMT

Hi Mounika - overall, there are several issues when trying to extract info from a sharepoint list in the person or group field. When you say you are getting the values, what do you actually see? Is it the email addresses or NT id's? Or, are you expecting to see full names? The later might not be possible since the raw data could only point to the IDs.

Keep us posted.

------------------------------
Alexander Marlowe
Blue Prism
Blue Prism
------------------------------

RE: SharePoint List Skill

MounikaBanda — Mon, 03 Aug 2020 19:47:00 GMT

Hi Alexander - I was expecting email addresses instead of the IDs. I was able to extract email address using ODATA Query -
getbytitle(ListName)/items?$select=ID,EmployeeName/EMail&$expand=EmployeeName/ID.

Thanks!

------------------------------
Mounika Banda
------------------------------

RE: SharePoint List Skill

AlexanderMarlow — Mon, 03 Aug 2020 19:53:00 GMT

Thanks for letting us know Mounika! I've had experience where usually you get an email alias and getting the email address requires a couple of steps or data wrangling. I'm glad you could figure it out with the ODATA query!

Good luck with your project!

------------------------------
Alexander Marlowe
Blue Prism
Blue Prism
------------------------------