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

All responses (2)

Answers (1)

Sort by

Jasir Qadri 36 on at

Like
a
(0)

Report
Copy link

Link copied!

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
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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,