In my app I have a collection called 'colProperty' that pulls its information from a SharePoint document library. This document library contains a column called 'Owners' that is a 'Person or Group' field.
The following function works and creates a distinct list of all the owners 'DisplayNames' in alphabetical order. However, I was wondering rather than using 2 collections (colAllOwners and colDistinctOwnersAtoZ), would it be possible to just use one collection to achieve a list of distinct Owners in alphabetical order? TIA
ClearCollect(colAllOwners, {});
ForAll(colProperty, Collect(colAllOwners, Owner.DisplayName));
ClearCollect(colDistinctOwnersAtoZ, Sort(Distinct(colAllOwners, DisplayName), Value, SortOrder.Ascending));
