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!
Solved! Go to Solution.
@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."
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."
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
209 | |
194 | |
82 | |
58 | |
38 |
User | Count |
---|---|
303 | |
249 | |
120 | |
83 | |
55 |