Forum Discussion
Solved
Connecting SharePoint List To Excel Doesn't Return Person Column Data
Hello, I had a question regarding the behaviour I am observing when I connect to a SharePoint Online list from Excel. Specifically, in Excel, I click on the data tab > get data > from online serv...
- I've since figured out how to resolve this issue and have posted a tutorial outlining the steps:
https://youtu.be/dJbwDTMXt74
Hi LuiIacobellis, as Hi, as ganeshsanap has said, this is a complex field type it will show this value. To get to the data underneath, you will need to use Power Query Editor and transform the data a little - here is some guidance on getting started with that: https://support.microsoft.com/en-us/office/about-power-query-in-excel-7104fbee-9e62-4cb9-a02e-5bfb1a6c536a
- Thank you!