Forum Discussion
NMenB
Apr 29, 2021Copper Contributor
Get Data Query from a SharePoint list
I am using Get Data to Query a SharePoint List. One of the fields namely "Owner" is a lookup Person or Group type to show Employee Name.
The list is showing "Employee Name" but when using the Get Data in Excel, it is showing Employee ID. How can I change this column "Owner" to show Employee Name in Excel?
Thanks.
3 Replies
- SergeiBaklanDiamond Contributor
Is that SharePoint Online or on-premises?
- NMenBCopper ContributorOnline
- SergeiBaklanDiamond Contributor
Try to check records in FieldValuesAsText or it could be another field with records for your field.