cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tbar
Regular Visitor

Filter data source using 2 search fields

I'm trying to filter my gallery by 2 different items.

Here is the code: (the user can type into search text box to filter on any of the fields in qoutes)

SortByColumns(Search('[dbo].[Pharmacy]',TextSearchBox1.Text,"PharmacyName","BdcOwner","ConsultantOwner","City","State","ZIPCode","NPI","StreetAddress"),"PharmacyName",Descending)

 

BUT, I need to integrate a filter on the entire data set regardless of what they search for.

&& Search('dbo.Pharmacy',"0",SuppressInd)

This is to look at the SuppressInd column, which contains a 1 or 0, and only display those records that are not suppressed.

Right now, i get errors.

 

Can anyone find a way to integrate the 2?

 

Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
CarlosFigueira
Power Apps
Power Apps

The Search function returns a "table" with the records filtered by the condition you passed. You can nest multiple search calls in the same expression, searching on the result of another search call:

SortByColumns(
    Search(
        Search('dbo.Pharmacy',"0",SuppressInd),
        TextSearchBox1.Text,
        "PharmacyName",
        "BdcOwner",
        "ConsultantOwner",
        "City",
        "State",
        "ZIPCode",
        "NPI",
        "StreetAddress"),
    "PharmacyName",
    Descending)

 If the column "SuppressInd" contains only the values 0 or 1, you can also use a Filter expression:

SortByColumns(
    Search(
        Filter('dbo.Pharmacy', SuppressInd = "0"),
        TextSearchBox1.Text,
        "PharmacyName",
        "BdcOwner",
        "ConsultantOwner",
        "City",
        "State",
        "ZIPCode",
        "NPI",
        "StreetAddress"),
    "PharmacyName",
    Descending)

View solution in original post

1 REPLY 1
CarlosFigueira
Power Apps
Power Apps

The Search function returns a "table" with the records filtered by the condition you passed. You can nest multiple search calls in the same expression, searching on the result of another search call:

SortByColumns(
    Search(
        Search('dbo.Pharmacy',"0",SuppressInd),
        TextSearchBox1.Text,
        "PharmacyName",
        "BdcOwner",
        "ConsultantOwner",
        "City",
        "State",
        "ZIPCode",
        "NPI",
        "StreetAddress"),
    "PharmacyName",
    Descending)

 If the column "SuppressInd" contains only the values 0 or 1, you can also use a Filter expression:

SortByColumns(
    Search(
        Filter('dbo.Pharmacy', SuppressInd = "0"),
        TextSearchBox1.Text,
        "PharmacyName",
        "BdcOwner",
        "ConsultantOwner",
        "City",
        "State",
        "ZIPCode",
        "NPI",
        "StreetAddress"),
    "PharmacyName",
    Descending)

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (51,353)