I have a Sharepoint column, type "Person or Group" (let's call it AllUsers), which allows me to select multiple users. In my Power App I have a Combobox which successfully uses Choices(SharePointSite.AllUsers) in the Items property to create a searchable list of users. By default it seems to only show the first 16 persons, however if I search for someone outside of those 16 it finds them correctly.
The problem I have is that I would like to filter that list, (e.g. to exclude users showing in a separate list), but I don't seem to be able to do so, either directly or via a collection, without losing the ability to search beyond the first 16 users displayed.
For example:
MyCombobox.Items = Choices(SharePointSite.AllUsers) <= works fine!
Filter(Choices(SharePointSite.AllUsers), !(Email="Joe.Bloggs@mycompany.com")) <= this correctly excludes Joe Bloggs from the visible list (assuming he is one of the 16 shown by default) but it won't let me search for "William" who isn't one of the 16.
Similarly, if I want to use a collection to populate the choice of items in the combobox I also lose full search capability:
CollectClear(MyCol, Choices(SharePointSite.AllUsers))
MyCombobox.Items = MyCol
(The actual collection I am creating is obviously a lot more complicated and appears to works fine from looking at the values appearing in the drop-down box, until I actually search for anyone!!)
Is this problem based on a wrong understanding of how combo-boxes work? Is it possible to use a filtered collection in this way??
Any help or advice would be greatly appreciated.
