I looked everywhere and cant find the solution.
I have a people column and ticked the box it to allow for multiple selections. I added a combobox filter in gallery, but cant work it out - how to make it work. I have tried concat, split and nothing 😞 Lets say the name of the column is "Leaders name" and the list name is "Records".
Any help will be very much appreciated. I already wasted 2 days on it 😞
Is it actually possible
Hi @batmanMon ,
I am assuming here that you want to search users in your AD with this box. Firstly, the Items of the Combo Box
Office365Users.SearchUser({SearchTerm: Self.SearchText})
Also ensure you edit the box with Primary and Secondary Text DisplayName and Mail
Now it gets a bit messy as things that in theory should work, but do not, so DefaultSelectedItems
ForAll(
ThisItem.Leaders As _Name,
{
Claims: "i:0#.f|membership|" & Lower(_Name.Email),
DisplayName: _Name.DisplayName,
Mail: _Name.Email,
Department: _Name.Department,
JobTitle: _Name.JobTitle,
Picture: _Name.Picture
}
)
and the Update of the Data Card
ForAll(
YourComboBox.SelectedItems As _Name,
{
Claims: "i:0#.f|membership|" & Lower(_Name.Mail),
DisplayName: _Name.DisplayName,
Email: _Name.Mail,
Department: _Name.Department,
JobTitle: _Name.JobTitle,
Picture: _Name.Picture
}
)
Note the swapping of Mail and Email as the Search in the Items changes this.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps
WarrenBelz
146,660
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,999
Most Valuable Professional