cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ArianskiDenso
New Member

Multiple Filter options CustomerID / First Name/ Last Name

Hello guys,

 

I would like to implement 3 different filtering options in a gallery. The first one is to search for the customer ID. The second by the first name and the third by the last name. What do I have to enter in ITEM-Property so that all three filters work? For the first name the filter works how can I include multiple filters?

 

Filter(SPList;TextInput_First_Name.Text in First Name)

 

ArianskiDenso_0-1649000627391.png

Thanks!

 

1 REPLY 1
Drrickryp
Super User
Super User

@ArianskiDenso 

You could have one text input and have the Items property of the gallery

Filter(
    SPlist,
    StartsWith(
        'Customer ID',
        TextInput1.Text
    ) || StartsWith(
        'First Name',
        TextInput1.Text
    ) || StartsWith(
        'last name',
        TextInput1.Text
    )
)

or for your example

Filter(
    SPlist,
    StartsWith(
        'Customer ID',
        txtCustomerID.Text
    ) || IsBlank(txtCustomerID.Text),
    StartsWith(
        'First Name',
        txtFirstName.Text
    ) || IsBlank(txtFirstName.Text),
    StartsWith(
        'last name',
        txtLastName.Text
    ) || IsBlank(txtLastName.Text)
)

You will need to change the names in the formula to the correct name for your textinput boxes.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (1,300)