I am using the 'Export as Data Feed' function to use a SharePoint 2010 list as a datasource for PowerPivot. Everything works fine, however, the 'User or Group' field is showing the user ID only. How do I show the name of the user?
For e.g. I selected a SP user, John Doe, it is showing a id of say, 20.
How do I display 'John Doe' on PowerPivot?
We are experiencing the same problem. What is the correct datafield? In the SharePoint list, we created a new column called Buyer and the 'Type' is Person or Group. This enables us to have a directory seach. In SharePoint, this works as expected. But when I create a PowerPivot model via the 'From Data Feeds', I only get a number value (BuyerID), rather than the name that was selected. What column needs to be added to my SharPoint list to ge the actual person's name for my PowerPivot report. We have search for all the obvious columns, like Name, Person or Group, etc. and not having any success. Thanks for the help!
I am experiencing the exact same issue. Any further info on this? I realize this is an old post, but hopefully this will bump it, and we can get some answers.
Or another way to solve this may be to import the user list too, and cross reference the number of the user to their real username so the powerpivot sheet looks like something we can understand, other than user 14 is 3 days late on his project. Need the username, not the ID, but the datafeed and powerpivot only bring in the ID number, not the name, there is not a choice as far as I can see to bring in the correct data, the column is configured for name, and I can't see how to find the user ID within the list, but that is the info that powerpivot brings out...... HELP please!
- Edited by SycoDuck Thursday, March 07, 2013 5:12 PM
I don't think the question they asked here had anything to do with datafield selection. The field that is the column in sharepoint Assigned To, or Modified by, or any column that contains a username in the sharepoint list, only comes into powerpivot as a number. So, me, John, comes in as a 14, not John. Dave is a 27, etc... How can we get the username, and not the user number? There appears to be no selection to allow this. The SP column is configured to only contain a name, why does it come into powerpivot as a number?
I was finally able to develop a work around. What I had to do is edit the form for this list in infopath. I added a field/column that was a text box in infopath, and used the formula to insert the desired field from the user field in the list.
The path to this field that contained the user's name was myfields\datafields\mysharepointlist\AssignedTo\pc:Person\DisplayName
Or the xpath is ../my:AssignedTo/pc:Person/pc:DisplayName
Once I did this, I saved the form, published the form back to my SP2010 site, and the newly created column is there when I connect powerpivot to my datafeed for this list. So now I have the original AssignedToId column that has the ID number which is useless to me, and the new AssignedToText column I created, which has the user's display name. This was all I needed, as I just needed the viewers of the PowerPivot table I created to know which user was behind on tasks.
I made a document with screenshots, etc. PM me if you are interested. (If PM is an option on this forum?)
- Proposed as answer by SycoDuck Friday, March 08, 2013 8:32 PM