Answered

Filter A Gallery by multiple Criteria

(0) Share

Report

Posted on by Tayohpeter

I have tried using this code that worked when I was connecting to SQL but it's not working now that I have changed the data source to Sharepoint list

can anyone help?

SortByColumns(Filter(
Search(
'[dbo].[M_qryStreetListWeb]_1',
Textinput1.Text,
""EnrollmentAreaID=cboEnrollmentArea.Selected.EnrollmentAreaID"",
),
"SI",
If(
SortDescending1,
Descending,
Ascending
)
)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

WarrenBelz 154,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Tayohpeter ,

What field are your wanting to Search as well as the drop-down selection and what is your Search control name, or do you just want to filter on the drop-down like this

SortByColumns( Filter( '[dbo].[M_qryStreetListWeb]_1', EnrollmentAreaID = cboEnrollmentArea.Selected.EnrollmentAreaID ), "SI", If( SortDescending1, Descending, Ascending ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Tayohpeter 25 on at

Like (0)

Report
Copy link

Link copied!

I want to search the SI field,
As seen in the image if I select an area all the SI tied to the area which is like what is typed would be displayed

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@Tayohpeter ,

Assuming you are using SQL here (add your Text Contol name)

SortByColumns( Filter( '[dbo].[M_qryStreetListWeb]_1', EnrollmentAreaID = cboEnrollmentArea.Selected.EnrollmentAreaID && YourTextBoxName.Text in SI ), "SI", If( SortDescending1, Descending, Ascending ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No