Solved: Conditionally Filter Gallery Items by Search-Criteria

Hi,

I have a gallery which shows a list of equipments at a certain location and a text-field "Search_Serial". If the text-field is empty the gallery should show all equipments of the selected location. If the text-field is not empty the items in the gallery should be filtered by location AND the text-field content:

If(
 IsBlank(Search_Serial.Text);
 Filter(
 Equipments_Offline;
 Location = Text(Gallery2_3.Selected.ID)
 );
 Filter(
 Equipments_Offline;
 Location = Text(Gallery2_3.Selected.ID) && Search_Serial.Text in Serialnumber
 )
)

Problem:

If I enter any text in the text-field nothing will be shown in the gallery. I even tried to filter by the location only for both conditions:

If(
 IsBlank(Search_Serial.Text);
 Filter(
 Equipments_Offline;
 Location = Text(Gallery2_3.Selected.ID)
 );
 Filter(
 Equipments_Offline;
 Location = Text(Gallery2_3.Selected.ID)
 )
)

The rseult is the same: No gallery items are shown if the text-field is not empty.

Categories:

General Questions