I have the below in my items property for a gallery:
With(
{
FutureDate:
DateAdd(Today(),90,TimeUnit.Days)
},
SortByColumns(
Filter(
Search(
Search(
Search(
Search(
AddColumns(
If(
varTabSelected = 1, 'NDT Cert Tracker',
varTabSelected = 2, Filter('NDT Cert Tracker', Name.Email = User().Email),
varTabSelected = 3, Filter('NDT Cert Tracker', Examiner.Email = User().Email),
varTabSelected = 4, Filter('NDT Cert Tracker', Supervisor.Email = User().Email),
varTabSelected = 5, Filter('NDT Cert Tracker', CertExp < FutureDate || 'YR 1 DUE' < FutureDate || 'YR 2 DUE' < FutureDate || 'TPE DUE' < FutureDate || 'ReInsp DUE' < FutureDate || 'YR 3 DUE' < FutureDate),
varTabSelected = 6, 'NDT Cert Tracker',
'NDT Cert Tracker'
),
DisplayName,
Name.DisplayName,
ExaminerDisplayName,
Examiner.DisplayName,
SupervisorDisplayName,
Supervisor.DisplayName
),
txtName.Text,
DisplayName
),
txtExaminer.Text,
ExaminerDisplayName
),
txtSupervisor.Text,
SupervisorDisplayName
),
txtCodeFilter.Text,
Code
),
(cbxMethod.Selected.Value = Method.Value || IsBlank(cbxMethod.Selected.Value)),
(cbxLevel.Selected.Value = Level.Value || IsBlank(cbxLevel.Selected.Value)),
(cbxLocation.Selected.Value = Location.Value || IsBlank(cbxLocation.Selected.Value))
),
"CertExp",
SortOrder.Ascending
)
)
It works but I would like the code filter that is typed into txtCodeFilter to search in order. When you type in 32 it filters to only things that start with 32 such as 322, 323 etc. but does not contain 332 or 342. How can I fix?
