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.
Free Windows Admin Tool Kit Click here and download it now
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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics