Filter Gallery by Dropdown and Text search box

(0) Share

Report

Posted on by Community Power Pla...

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)

Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report
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... on at

Like (0)

Report

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