cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Lukas1
Level: Powered On

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Dual Super User
Dual Super User

Re: Conditionally Filter Gallery Items by Search-Criteria

In the documentation for IsBlank() there is the following entry...

To test specifically for a blank value use if( Value = Blank(), ... instead of IsBlank.

 

So try the following for your If statement and see if it helps.

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

 



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

1 REPLY 1
Dual Super User
Dual Super User

Re: Conditionally Filter Gallery Items by Search-Criteria

In the documentation for IsBlank() there is the following entry...

To test specifically for a blank value use if( Value = Blank(), ... instead of IsBlank.

 

So try the following for your If statement and see if it helps.

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

 



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 367 members 6,537 guests
Please welcome our newest community members: