cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dave9
Frequent Visitor

Distinct list of People from Multi Selection People Picker

Hello, 

 

Ive see several posts about people pickers, but my sharepoint list allows for multiple people to be selected. which means that the people picker column is a column of tables. 

 

I want to create a list view where the items are the distinct people from the people picker column.  AND I want to filter the sharepoint list so that you can see which items from the sharepoint list each person was involved with. 

 

Im not sure that this is possible based on my current experimentation, but I thought Id ask.

 

Thanks!

 

EDIT:    For others who may be interested, my actual solution used Ungroup and then GroupBy.

 

ClearCollect(colAuditors, GroupBy(Ungroup(dataSource, "GroupedColumnName"),"DisplayName","Email","Picture", "GroupedData"))

 

thank you @mdevaney  for your help with this solution!

1 ACCEPTED SOLUTION

Accepted Solutions

@Dave9 
This will give you a list of all the people's names as plain text but I am not sure if that is what you wanted.

 

ClearCollect(colUniqueNames, Distinct(Ungroup(your_datasource_name, your_column_name), DisplayName))  

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."  

View solution in original post

3 REPLIES 3
mdevaney
Super User
Super User

@Dave9 

Please provide an example of what the resulting table should look like.

Sharepoint Item 1:  people picker:  Dave, Joe, Bob

Sharepoint Item 2:  people picker:  Dave, Bob, Mary

Sharepoint Item 3:  people picker:  Mary, Joe

 

Powerapps List screen Items:  Dave, Joe, Bob, Mary

 

the people picker uses O365 people, so each person is a record. 

@Dave9 
This will give you a list of all the people's names as plain text but I am not sure if that is what you wanted.

 

ClearCollect(colUniqueNames, Distinct(Ungroup(your_datasource_name, your_column_name), DisplayName))  

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."  

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (4,687)