Search to be added in my formula

(0) Share

Report

Posted on by Jasir Qadri

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

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Jasir Qadri 36 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (0)

Report
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,

Was this reply helpful? Yes No