Filter Gallery by Dropdown and Text search box

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I am trying to filter a Gallery by Dropdown and Text search box.

I tried this code↓

SortByColumns (Search (Filter ('DTC List for App', Title= Dropdown1.Selected.Value),TextSearchBox1.Text,"Identifier"),"Title",If (SortDescending1,Descending,Ascending))

Filter without Dropdown is like this, ↓

SortByColumns (Filter([@'DTC List for App'], StartsWith (Identifier, TextSearchBox1.Text)),"Identifier", If (SortDescending1, Descending, Ascending))

CIOM→”Title”, B000101→"Identifier"

I want to filter Title by Dropdown and Identifier by Text Search Box.

Could anyone show how I can make it work?

Thank you,

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hey @Anonymous

Can you please confirm if you are getting any error while using the below expression?

SortByColumns (Search (Filter ('DTC List for App', Title= Dropdown1.Selected.Value),TextSearchBox1.Text,"Identifier"),"Title",If (SortDescending1,Descending,Ascending))

Please share more information about the part where you need help with the expressions?

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

The Gallery didn't show any data when I tried the code I pasted,
but it worked this time!

Thank you very much!

Was this reply helpful? Yes No