Below is in my items property for a gallery. I am trying to make the SearchInput_tb.Text searchable by anything. Right now I can only search for the title when it starts with something. Any way for it match up to anything in that search box? How could I alter below?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
With(
{
_prefiltered_data: Filter(
'eCom Intake',
Status.Value = "Open - Assigned",
Len(Dropdown4.Selected.Value) = 0 || LOB.Value = Dropdown4.Selected.Value,
Len(Dropdown4_1.Selected.Value) = 0 || 'Issue Type'.Value = Dropdown4_1.Selected.Value
)
},
With(
{
_filtered_by_names: Filter(
_prefiltered_data,
Len(SearchInput_tb.Text) = 0 || StartsWith(
Title,
SearchInput_tb.Text
) || StartsWith(
'Created By'.DisplayName,
Trim(SearchInput_tb.Text)
) || StartsWith(
AssignedTo.DisplayName,
Trim(SearchInput_tb.Text)
)
),
_filtered_by_id: Filter(
_prefiltered_data,
Len(SearchInput_tb.Text) = 0 || ID = Value(SearchInput_tb.Text)
)
},
With(
{
_finaltable: If(
!SearchID_tg.Checked && !SearchRequestor_tg.Checked,
_filtered_by_names,
_filtered_by_id
)
},
Sort(
_finaltable,
ID,
SortOrder.Ascending
)
)
)
)
