Hi @amel0410 ,
If you want multiple Search Boxes for different Columns, if Kode, OJK, example refers to columns in Table1 then,
Filter(Table1,(KodeSearch.Text in Kode) || (DescSearch.Text in OJK) || (ExampleSearch.Text in example)).
If you want single search box for multiple columns then refer below formula,
SortByColumns(
Filter(
'CM_Contracts Management',
StartsWith(
'Contract No.',
InpSearch_1.Text
) || (InpSearch_1.Text in 'People'.DisplayName)
),
"Created",
If(
SortDescending,
Ascending,
Descending
)
)
// Use Sort icon to sort the gallery record and OnSelect of it apply "UpdateContext({SortDescending: !SortDescending})" to toggle sort function.
Refer below code,
SortByColumns(
Filter(
'CM_Contracts Management',
StartsWith(
'Contract No.',
InpSearch_1.Text
) || (InpSearch_1.Text in 'People'.DisplayName)
|| StartsWith(
ContractType.Value,
InpSearch_1.Text
) || StartsWith(
Mandant.Value,
InpSearch_1.Text
) || StartsWith(
Department.Value,
InpSearch_1.Text
) || StartsWith(
Active.Value,
InpSearch_1.Text
) || StartsWith(
ContractingCompany.Value,
InpSearch_1.Text
) || StartsWith(
ShortDescriptionContat,
InpSearch_1.Text
) || StartsWith(
Subcontracts,
InpSearch_1.Text
) || StartsWith(
ExternalContact,
InpSearch_1.Text
) || StartsWith(
SignDate,
InpSearch_1.Text
) || StartsWith(
StartContract,
InpSearch_1.Text
)
|| StartsWith(
'Created By'.DisplayName,
InpSearch_1.Text
)
|| StartsWith(
OneTimeCosts,
InpSearch_1.Text
)
|| StartsWith(
CostPerPeriod,
InpSearch_1.Text
)
),
"Created",
Descending
)
