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!
Solved! Go to Solution.
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)
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)
Check out new user group experience and if you are a leader please create your group
Did you miss the call?? Check out the Power Apps Community Call here!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
275 | |
246 | |
84 | |
37 | |
33 |
User | Count |
---|---|
342 | |
246 | |
130 | |
73 | |
44 |