Apr 29 2021 09:10 AM
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.
Apr 29 2021 09:47 AM
Is that SharePoint Online or on-premises?
Apr 29 2021 01:40 PM
Try to check records in FieldValuesAsText or it could be another field with records for your field.