Hello community,
I have the following problem:
I only want to see the data in a gallery that I have previously filtered and still want to have the option to search for individual items.
This is how it looks like:
I figured out how to create the code for filtering via the text search box and how to filter via the tiles individually:
Here is my code for filtering via the text search box:
SortByColumns(Search([@Table1], TextSearchBox1.Text, "FIXEDASSETNUMBER","ACTIVITYCODE","BARCODE"), "FIXEDASSETNUMBER", If(SortDescending1, Descending, Ascending))
Here is the code for filtering via the tiles:
If(
Gallery1.Selected.Value = "All",
Filter(
Table1,
StartsWith(
"FIXEDASSETNUMBER",
TextSearchBox1.Text
)
),
Filter(
Table1,
StartsWith(
"FIXEDASSETNUMBER",
TextSearchBox1.Text
)&& OVERDUE = Gallery1.Selected.Value
)
)
My question: How can I combine this code?
(I am working with a excel file as my data source)
Thank you very much for your help!
