Filter Galary by Dropdown and Text

(0) Share

Report

Posted on by Xeon0021

116

Hello Community,

I have a galary that I shall be able to filter with a dropdown and by a searchbox. I already have both functions and they work for itself but I don't know how to combine them. I hope you can help me out!

Filter(Einheit, BE_FilterDropdown.Selected.Bezeichnung = "Keine" || EinheitArtikelNr = LookUp(Artikel, GeräteTypID = LookUp(GeraeteTyp,Bezeichnung = BE_FilterDropdown.Selected.Bezeichnung,TypID),ArtikelNr))

and

SortByColumns(Search(Einheit, TextSearchBox1.Text, "Bezeichnung","MitarbeiterAnzeigeName","Status"), "Bezeichnung", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))

Best Regards

Leon

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Xeon0021 116 on at

Like (1)

Report
Found it out by myself 😄

Filter(SortByColumns(Search(Einheit, TextSearchBox1.Text, "Bezeichnung","MitarbeiterAnzeigeName","Status"), "Bezeichnung", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending)), BE_FilterDropdown.Selected.Bezeichnung = "Keine" || EinheitArtikelNr = LookUp(Artikel, GeräteTypID = LookUp(GeraeteTyp,Bezeichnung = BE_FilterDropdown.Selected.Bezeichnung,TypID),ArtikelNr))

Was this reply helpful? Yes No