Answered

Text search box + combo box filter

(0) Share

Report

Posted on by Kakadu

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

EdViegas 436 on at

Like (1)

Report
Copy link

Link copied!
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 ) )

Was this reply helpful? Yes No
Kakadu 7 on at

Like (0)

Report
Copy link

Link copied!

Had to modify it a bit, but it works!
Thank you very much @EdViegas for support 🙂

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Kakadu,

Could you please Mark the replay as an answer?

Thanks for your cooperation.

Was this reply helpful? Yes No