Get Data Query from a SharePoint list

Copper Contributor

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

@NMenB 

Is that SharePoint Online or on-premises?

Online

@NMenB 

Try to check records in FieldValuesAsText or it could be another field with records for your field.