@ScablandsKing - does not work that way. If you want to run the Search function against different controls, you will need to chain multiple Search functions together:
Filter(
Search(
Search(
Search(
AddColumns(
'NDT Tracker',
DisplayName,
Name.DisplayName,
AnotherDisplayName,
Examiner.DisplayName,
YetAnotherDisplayName,
Supervisor.DisplayName
),
txtName.Text,
DisplayName
),
txtSupervisor.Text,
AnotherDisplayName
),
txtExaminer.Text,
YetAnotherDisplayName
),
Len(cbxMethod.Selected.Value) = 0 || Method.Value = cbxMethod.Selected.Value,
Len(cbxLevel.Selected.Value) = 0 || Method.Value = cbxLevel.Selected.Value
)
The below returns the same output as above, but in my opinion is more readable:
With(
{
_prefiltered_data: Filter(
'NDT Tracker',
Len(cbxMethod.Selected.Value) = 0 || Method.Value = cbxMethod.Selected.Value,
Len(cbxLevel.Selected.Value) = 0 || Level.Value = cbxLevel.Selected.Value
)
},
With(
{
_transformed_data: AddColumns(
_prefiltered_data,
DisplayName,
Name.DisplayName,
AnotherDisplayName,
Examiner.DisplayName,
YetAnotherDisplayName,
Supervisor.DisplayName
)
},
Search(
Search(
Search(
_transformed_data,
txtName.Text,
DisplayName
),
txtSupervisor.Text,
AnotherDisplayName
),
txtExaminer.Text,
YetAnotherDisplayName
)
)
)
