Sharepoint people picker fields

Question

Hi,

I have some people picker columns in a sharepoint list that display, full name office location, phone number,etc.  When I "export as a data feed" to PowerPivot, the columns only display the ID number.  same goes for the CreatedBY and ModifiedBy fields.  Is there an easy way to get the actual name, phone number, etc to display in the PowerPivot table?

Thanks!

Paul

Answer 1

Hi Paul,

By defaul, besides the user-defined columns, some property columns will also export to the Data Feed, this behavior is by design, if you do not want to conclude these property column, you can utilize "Preview&Filter" to filter these property columns.

For more information about Using SharePoint List Data in PowerPivot, please see this white paper http://blogs.msdn.com/b/analysisservices/archive/2011/06/10/white-paper-published-using-sharepoint-list-data-in-powerpivot.aspx

If I misunderstand you, please feel free to let us know.

Thanks,

---

Challen Fu

TechNet Community Support