Hi
I'm struggling with setting up filtering by text in textsearchbox (TextSearchBoxBooking) and combobox (ComboBox1) value.
Here's how my formula looks like at the moment:
SortByColumns(Filter([@KitBooking_test], StartsWith(Title, TextSearchBoxBooking.Text)), "ID", If(SortDescending1, Descending, Ascending))
I have tried a few different setups but none of these worked so far.
For example, i need to filter by item name put into the text search box, but also I need to be able to filter by statuses of items, which are listed in the combo box.
The data source for this app is a single SharePoint.
Had to modify it a bit, but it works!
Thank you very much @EdViegas for support 🙂
Assuming that Statuses is a LookUp column, try:
SortByColumns(
Filter(
[@KitBooking_test],
And(
StartsWith(Title, TextSearchBoxBooking.Text),
Or(
ComboBox1.Selected.ID = Status.Value,
IsBlank(ComboBox1.Selected.ID)
)
)
),
"ID",
If(
SortDescending1,
Descending,
Ascending
)
)