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?

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.

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.