Search to be added in my formula

[jasirqadri123]

Hi Everyone,

Where should i add my search function in this formula,

SortByColumns(If(sortAll,Filter(RepairOrderTables,Status = Dropdown.Selected.Value && Site = varsite.Site && (If(techAll,Technician = Dropdown1.SelectedText.Value,Site = varsite.Site))),Filter(RepairOrderTables,Site = varsite.Site && (If(techAll,Technician = Dropdown1.SelectedText.Value,Site = varsite.Site,If(!IsBlank(DatePickerStart.SelectedDate) && DatePickerStart.SelectedDate <= DatePicker.SelectedDate,OrderDate <= DatePicker.SelectedDate && OrderDate >= DatePickerStart.SelectedDate,OrderDate <= DatePicker.SelectedDate))))),"OrderDate",If(SortDescending1,Ascending,Descending),"OrderId",Descending)

Search formula is: Search(RepairOrderTables, TextInput.Text, "OrderId", "Customer").

for my gallery to search these items

[jasirqadri123]

Also if Filter(RepairOrderTables,StartsWith('OrderId',TextInput.Text) || StartWith('Customer'.DisplayName,TextInput.Text))

Where i can insert this in my above main formula as i am not able to get in in

[v-jefferni · Accepted solution]

Hi @jasirqadri123 ,

As the original formula shares the same data source with the Search function, you can replace the data source parameter with the original formula and easily achieve your need:

Search(
    SortByColumns(If(sortAll,Filter(RepairOrderTables,Status = Dropdown.Selected.Value && Site = varsite.Site && (If(techAll,Technician = Dropdown1.SelectedText.Value,Site = varsite.Site))),Filter(RepairOrderTables,Site = varsite.Site && (If(techAll,Technician = Dropdown1.SelectedText.Value,Site = varsite.Site,If(!IsBlank(DatePickerStart.SelectedDate) && DatePickerStart.SelectedDate <= DatePicker.SelectedDate,OrderDate <= DatePicker.SelectedDate && OrderDate >= DatePickerStart.SelectedDate,OrderDate <= DatePicker.SelectedDate))))),"OrderDate",If(SortDescending1,Ascending,Descending),"OrderId",Descending), 
    TextInput.Text, 
    "OrderId", 
    "Customer"
)

Best regards,