Parse SharePoint Multiple Person List into Separate Rows
I am trying to use a SharePoint multiple-person field to create a report of all distinct users, with one person per line. I am having problems creating this and could use any suggestions. Consider this example list: SharePoint List Row 1: 1;#John,2;#Jane,3;#Jim SharePoint List Row 2: 2;#Jane SharePoint List Row 3; 1;#John,3;#Jim I would like the output to be: Report Row 1: John Report Row 2: Jane Report Row 3: Jim And no further rows. Suggestions?
November 5th, 2012 3:43pm
Hi, I'm afraid this won't be possible, or at least I don't see any method for this... The problem being that the Microsoft SharePoint List extension is very limited. A possible solution would involve using a third party extension that we developed. But you will have to pay for it. Let me know if you want further info on this.
November 6th, 2012 10:14am
Hello, In order to try and solve this problem I put in a grouping on the SharePoint List and hid repeated rows. Unfortunately I can't find a way to parse a column into multiple rows, so I am trying a different approach altogether.
November 6th, 2012 4:23pm