Combobox Filter, Search and Sort

Like (1) Share

Report

Posted on 8 Apr 2025 17:33:53 by kmw1130

948

I have a Combobox that is getting the values from another SharePoint list. The functions I currently have work as expected, but would like the Combobox values to be sorted ascending. NOTE: My data is a large data set.

My ComboBox fields are:

My items function is:

Filter(Employees, EmpStatus.Value = "Active", StartsWith(Employee, Self.SearchText))
 
My defaultselecteditems is:
If(!IsBlank(SharePointIntegration.Selected), LookUp(Employees, EmployeeEmail.Email=ThisItem.EmployeeEmail))

Categories:

General

All responses (2)

Answers (1)

kmw1130 948 on 08 Apr 2025 at 18:36:04

Like (0)

Report

Combobox Filter, Search and Sort

@GabGadou

That worked great! Thank you!
Verified answer

GabGadou 653 on 08 Apr 2025 at 17:56:58

Like (1)

Report

Combobox Filter, Search and Sort

Hi,

You simply use Sort on your 'items' property of combobox:
Sort(Filter(Employees, EmpStatus.Value = "Active", StartsWith(Employee, Self.SearchText)), txtEmployeeEmail)

you can use another field onstead of txtEmployeeEmail if you want. If you need 'Descending', you add SortOrder.Descending as third argument for Sort function.

I hope it helps!

_________________________________________________

Please click Does this answer your question 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 a Like.