Power Platform Community Forum Thread Details

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!

Categories:

Building 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)