For this post I will describe a much more basic example to what I am actually doing, but the concept is the same.
I have a SharePoint list with a People Picker column. You can select multiple people in this column.
I want to display all the people in a gallery
My gallery should contain any name that is in any List Item's "Employee" people picker field.
Thanks for any help.
button.OnSelect =
Clear(colDistinctPeopleFinal);
ForAll( Distinct(SP_list, Employee) As ThisMultiPeople,
ForAll(ThisMultiPeople.Result As ThisPerson,
If( !(ThisPerson in colDistinctPeopleFinal),
Collect(colDistinctPeopleFinal, ThisPerson)
)
)
);
gallery.Items = SortByColumns(colDistinctPeopleFinal, "DisplayName", Ascending)
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
193 | |
67 | |
46 | |
41 | |
27 |
User | Count |
---|---|
253 | |
120 | |
86 | |
84 | |
84 |